I've had a DEVIL of a time with this problem and I'm sure it's something
simple, but I can't find it anywhere in the documentation or online what the
problem is. Let me explain.
I cannot get any WHILE loop to work from either a CLI or a script on MySQL
5.1.41. For example, this is a simple
2011/12/27 18:13 +, 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
On 12/27/2011 12:13 PM, Mark Haney wrote:
I've had a DEVIL of a time with this problem and I'm sure it's something
simple, but I can't find it anywhere in the documentation or online what the
problem is. Let me explain.
I cannot get any WHILE loop to work from either a CLI or a script on