MySQL中declare这么用为什么会出错？

Question

You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near
'DECLARE @nCnt int, @Sno varchar(20),@Sname varchar(20) set @nCnt = 1 while @nCnt' at line 1 0.000 sec

Answer 1

mysql只能在存储过程或者函数内申明变量的，和sqlserver不一样