Select Clause MySQL

  1. Home
  2. MySQL
  3. Select Clause
  4. Assign a constant to a variable
mysql>
mysql> SELECT   @EmployeeNO := 7;
+------------------+
| @EmployeeNO := 7 |
+------------------+
|                7 |
+------------------+
1 row in set (0.00 sec)
mysql>