Mega Code Archive

 

Categories / MySQL / Select Clause

 

Assign a constant to a variable

mysql> mysql> SELECT   @EmployeeNO := 7; +------------------+ | @EmployeeNO := 7 | +------------------+ |                7 | +------------------+ 1 row in set (0.00 sec) mysql>