mysql DECLARE WHILE outside stored procedure how?

Question

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

Answer 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.