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

January 7, 2024 by Tarik

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'