What is wrong with this MySQL statement: DECLARE @ID INT

Question

DECLARE @ID INT ;

This statement is very good at MS SQL Server, but it gives me

You have an error in the SQL syntax; check the manual that matches your version of MySQL server for the correct syntax to use next to "DECLARE @ID INT" on line 1

Does anyone have an idea of ​​the reason?

Answer 1

DECLARE is used in stored procedures / functions.

If you want to set a variable for regular queries only, use SET

Answer 2

try assigning a value to a variable without @

DECLARE id INT;

Answer 3

Declare .

:

SET @ID =(Select id from mytable)