Select Clause MySQL

  1. Home
  2. MySQL
  3. Select Clause
  4. SELECT statement includes three select list elements
mysql>
mysql> SELECT 1+3, 'CD Inventory', NOW() AS 'Date/Time';
+-----+--------------+---------------------+
| 1+3 | CD Inventory | Date/Time           |
+-----+--------------+---------------------+
|   4 | CD Inventory | 2011-10-03 20:56:36 |
+-----+--------------+---------------------+
1 row in set (0.00 sec)
mysql>