>>>> 2011/12/27 18:13 +0000, Mark Haney >>>> So, what the heck is going on here? I'm at the end of my wits. <<<<<<<< I suspect that you have to make the block delimiter something other than semicolon, and set the block in a routine or trigger.
Semicolon terminates SQL routine statements, after PL1. If the block delimiter also is semicolon, parsing the block begins too early. In many examples of routine declaration it is changed to //, or another string not found in the block or routine. I often use question mark, but, of course, that is useless in case of "PREPARE". -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql