Mega Code Archive

 

Categories / MySQL / Select Clause

 

Identifying What Values to Display

mysql> mysql> SELECT 2+2, REPEAT('x',5), DATE_ADD('2001-01-01',INTERVAL 7 DAY), 1/0; +-----+---------------+---------------------------------------+------+ | 2+2 | REPEAT('x',5) | DATE_ADD('2001-01-01',INTERVAL 7 DAY) | 1/0  | +-----+---------------+---------------------------------------+------+ |   4 | xxxxx         | 2001-01-08                            | NULL | +-----+---------------+---------------------------------------+------+ 1 row in set (0.00 sec)