How to declare a variable in MySQL for a normal query?

Question

How can I declare a variable for a normal query in MySQL?

e.g.,

declare @myVar date;
set @myVar = something;

select * from someTable where someColumn = @myVar;

I tried and the syntax seems to be wrong...what am I missing?

Answer 1

You can declare a session variable in this way :

SET @myvarname := 'value';

or a local variable in this way :

DECLARE my_variable varchar(30)

also:

DECLARE my_variable varchar(30) DEFAULT 'value'