Just installed sql on ubuntu 21.04.
$ mysql -V mysql Ver 8.0.26-0ubuntu0.21.04.3 for Linux on x86_64 ((Ubuntu))
Wrote a test.sql file:
declare @a as int=4
On executing mysql> source /home/home/test.sql on the command line, the following error is returned:
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 @a as int=4' at line 1
adding begin and end to the script doesn’t help either. What is the fix?
Answers:
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
Method 1
First you need to declare the variable
DECLARE @MyVariable INT;
and then you can set it
SET @MyVariable = 1;
Method 2
You can only use declared variables in stored procedure. In an ordinary SQL script, use user variables, which are names beginning with @. You don’t specify a type, they can hold any type of value.
SET @a = 4;
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0