Tagged Questions
0
votes
0answers
208 views
MySQL: Get info from SHOW ERRORS
How can I get the info (code and message fields) from SHOW ERRORS? Or even, how can I insert this information into a table to keep tracking the errors?
Something like
SELECT CONCAT(Code,' - ', ...
6
votes
1answer
266 views
CATCH block is triggered when it should not
On my neverending quest for shooting myself in the foot with save transaction I seem to have found even more ways to fulfill the quest purpose. The save transaction clause itself this time is out of ...
5
votes
2answers
432 views
Error handling in container procedures
I'm aware of and use the techniques in this question.
In my environment we have a lot of container procedures that call subprocedures, that may call other procedures, ad infinitum.
For me ...
1
vote
1answer
2k views
Function returning “No data - zero rows fetched, selected, or processed” in MySQL 5.5
I have upgraded MySQL version to 5.5.16
After upgrading, some of the functions are giving warning as No data - zero rows fetched, selected, or processed.
In those functions, cursors are there, but ...
