Organizational Research By

Surprising Reserch Topic

mysql declare while outside stored procedure how


mysql declare while outside stored procedure how  using -'mysql'

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
    

asked Oct 6, 2015 by vimaldas2005
0 votes
7 views



Related Hot Questions

1 Answer

0 votes

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.

answered Oct 6, 2015 by girisha

...