Slide 54
Slide 54 text
ORDER BY
PRIMARY KEYなしで作る
mysql80 8> CREATE TABLE t3 (num int, val varchar(32));
Query OK, 0 rows affected (0.02 sec)
mysql80 8> INSERT INTO t3 VALUES (1, 'one'), (2, 'two'), (3, 'three');
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql80 8> SELECT * FROM t3; -- ORDER BYがないSELECTは行が見つかった順に返す
+------+-------+
| num | val |
+------+-------+
| 1 | one |
| 2 | two |
| 3 | three |
+------+-------+
3 rows in set (0.00 sec)
53/77