Mega Code Archive

 

Categories / MySQL / Select Clause

 

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>