mysql - aqua 数据工作室 mysql 变量

Question

当连接到 MySQL 数据库时，如何在 aqua data studio 中使用变量？这是一个简单的例子:

set @var = 1
select @var

或

set @var = 1;
select @var;

这会导致以下错误

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 'select @var' at line 2 

Answer 1

set @var = 1
go
select @var
go

或者这个...

set @var = 1
/
select @var
/