How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”

by

I guess you just forgot to include the following line in your post:

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

Your code is correct, but bug/strange behaviour of mysql causes the warning to appear even if it was handled. You can avoid that if you add a “dummy” statement to the end of your procedure that invovles a table and is successful, this will clear the warning. (See http://dev.mysql.com/doc/refman/5.5/en/show-warnings.html)
In your case:

SELECT name INTO l_name FROM customer_tbl LIMIT 1;

after the end of the loop.
On MySQL 5.5.13 the warning disappears, on Linux and Windows.
I commented on MySQL Bug 60840 and I hope they will fix it some time in the future…

More Related Contents:

  1. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  2. Can a stored procedure/function return a table?
  3. Is it possible to have a default parameter for a mysql stored procedure?
  4. You can’t specify target table for update in FROM clause
  5. Paging with Oracle
  6. How do I make a row generator in MySQL?
  7. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  8. MySQL number of items within “in clause”
  9. Error 1046 No database Selected, how to resolve?
  10. What’s the difference between VARCHAR and CHAR?
  11. Alter a MySQL column to be AUTO_INCREMENT
  12. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  13. single fixed table with multiple columns vs flexible abstract tables
  14. MySQL remove duplicates from big database quick
  15. How to delete from select in MySQL?
  16. What is the difference between function and procedure in PL/SQL?
  17. How to delete Duplicates in MySQL table
  18. How to ORDER BY a SUM() in MySQL?
  19. Selecting Random Rows in MySQL
  20. Why execute stored procedures is faster than SQL query from a script?
  21. Error: The used SELECT statements have a different number of columns
  22. How to Optimize Queries in a Database – The Basics
  23. In SQL Server, what does “SET ANSI_NULLS ON” mean?
  24. Any way to achieve fulltext-like search on InnoDB
  25. How to get Return Value of a Stored Procedure
  26. Functions with variable number of input parameters
  27. What does collation mean?
  28. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment