Select Clause MySQL

  1. Home
  2. MySQL
  3. Select Clause
  4. 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)