mysql DECLARE WHILE outside stored procedure how?
I fairly new to mysql but have MS SQL experience.
Is it possible to declare variables and use while statement outside stored procedure?
I only found examples where guys doing like this
1. procedure created
2. execute proc
3. drop proc
Suggest me the right way
Solution 1:
No, you cannot do it. You can use these statements only inside BEGIN...END clause.
So, it is possible in stored procedures/functions, triggers and events.
More information here - MySQL Compound-Statement Syntax.