Open cprieto opened 2 years ago
Support set variables for certain SQL dialects.
SET [GLOBAL | SESSION] [@]variable = value;
SET [LOCAL | SESSION] variable [=|TO] value
SQL Server cannot set a variable without declaring it first:
DECLARE @variable INT; SET @variable = 1;
In MySQL, the prefix @ is optional while in SQL Server is required.
@
SQLite does not support setting variables.
Support set variables for certain SQL dialects.
SET [GLOBAL | SESSION] [@]variable = value;SET [LOCAL | SESSION] variable [=|TO] valueSQL Server cannot set a variable without declaring it first:
In MySQL, the prefix
@is optional while in SQL Server is required.SQLite does not support setting variables.