mysql中用declare定义变量值时报错

关键字：mysql 更新时间：2018-05-25 04:21:08 3436次访问

mysql> select version();

+------------+

| version()  |

+------------+

| 5.5.32-log |

+------------+

1 row in set (0.00 sec)

mysql> declare name varchar(50);

ERROR 1064 (42000): 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 name varchar(50)' at line 1

mysql的declare 只能用于存储过程或函数中

不能直接在命令行使用的

相关标签：mysql