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 […]
This looks like it is going to be an issue for me in the near future. Looks like everything needs to go from latin1 to utf8. http://www.bluebox.net/news/2009/07/mysql_encoding
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 […]