CODEWITHSUNDEEP
mysqlvariablesvariable-declaration
EOB
EOB

Reputation: 3085

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

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?

Upvotes: 32

Views: 69418

Answers (1)

aleroot
aleroot

Reputation: 72676

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'

Upvotes: 44

Related Questions