在SQLYOG里如何执行多条语句
在SQLYOG里如何执行多条语句
DECLARE var1,var2,var3 INT;
SET var1=10,var2=20;
SET var3=var1+var2;
Query: declare var1,var2,var3 int
Error Code: 1064
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 var1,var2,var3 int' at line 1
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.003 sec
---------------------------------------------------
Query: set var1=10,var2=20
Error Code: 1193
Unknown system variable 'var1'
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0 sec
---------------------------------------------------
Query: set var3=var1+var2
Error Code: 1193
Unknown system variable 'var3'
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0 sec
---------------------------------------------------