mysql语句参数化,参数化MySQL工作台语句：如何定义变量

I'm trying to parameterize a set of frequently used queries in my workbench.

This works:

select * from providers where id='112233';

This

WbVarDef var1=112233;

select * from providers where id='$[var1]';

gives error

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'from providers where id='112233'' at line 1

My reference was this.

Just to be clear, these are in the MySQL workbench and not a workbench script file or a mysql script file.

解决方案

In MySQL, syntax for setting variable is below.

SET @var1 = '112233';

and using the variable would be as below.

select * from providers where id=@var1;

Check out MySQL documentation for more information Link to MySQL Documentation