全レコードを表示する「ALL」句
mysql> SELECT ndate FROM t_hanbai; +------------+ | ndate | +------------+ | 2005-07-11 | | 2005-07-12 | | 2005-07-12 | | 2005-07-21 | | 2005-07-22 | +------------+ 5 rows in set (0.00 sec) mysql> SELECT ALL ndate FROM t_hanbai; +------------+ | ndate | +------------+ | 2005-07-11 | | 2005-07-12 | | 2005-07-12 | | 2005-07-21 | | 2005-07-22 | +------------+ 5 rows in set (0.00 sec)