Question

有谁知道为什么我在mysql中创建存储过程无法定义变量啊！在里面一定义就报错。 定义DECLARE a int

报错信息：
ERROR 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 a INT ';

Answer 1

DECLARE @a INT 变量要加@符号

Answer 2

DECLARE @a INT