Handler Issus with MySQL

Working with MySQL 5.5.9, I ran into an issue where a cursor loop in 1 procedure was getting stopped by the INSERT … SELECT in a called procedure. The fix was not pretty but was effective: put a SET in the code to force the HANDLER back to FALSE(0) after the CALL that was setting […]

Read More →

SQL Prepared Statements

I have not used prepared statements before, this looks like a great feature for repetitive queries. MySQL :: Prepared Statements So in pseudo code: prepare sqldo     set parameter(s)     execute     actions….donerelease Did this on a fairly involved php page and quite honestly the data was inconclusive at best: CASE              Queries    Run 1    Run 2     Run […]

Read More →