MySQL – zmienne

Definiowanie zmiennych – kilka wersji

W procedurach

DECLARE user CHAR(77) CHARACTER SET utf8;
SET     user = (SELECT CURRENT_USER());

SELECT CONCAT('Witaj, ', user, '!') AS greeting; 

W skryptach

 SET @today          := CURDATE();
 SET @ten_years_ago  := DATE_SUB( @today, INTERVAL 10 YEARS );

Użycie zmiennych

SELECT @jackson_birth := birth FROM ...... 

SELECT * FROM president WHERE birth < @jackson_birth ORDER BY birth;