mysql - 在 heidisql 查询选项卡中声明 mysql 变量

Question

我像这样在 heidisql 选项卡中声明了一个变量

DECLARE total_count INT DEFAULT 0;
SET total_count = 10;
select total_count;

但是我得到了这个错误

/* SQL 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 total_count INT DEFAULT 0' at line 1 / / Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 3 queries: 0.000 sec. */

我应该像我所做的那样声明、设置和使用变量，还是必须将所有内容包装在存储过程或函数中？

Answer 1

试试这个:

SET @total_count := 10;
select @total_count;