2007-01-05から1日間の記事一覧

「LIMIT」句で引き出すレコード数を制限する

SQL

mysql> SELECT * FROM t_hanbai limit 1,3; +----+------------+------+--------+-------+ | id | ndate | tkcd | shcd | suryo | +----+------------+------+--------+-------+ | 2 | 2005-07-12 | 1001 | 100101 | 3 | | 3 | 2005-07-12 | 1002 | 100201 |…

「DISTINCT」句で重複するデータを一つにまとめて表示

SQL

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 DISTINCT ndate FROM t_hanbai; +----…

全レコードを表示する「ALL」句

SQL

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; +---------…