CREATE TABLE t1 (id INT PRIMARY KEY, c INT) ENGINE=Memory;
CREATE TABLE t2 (id INT PRIMARY KEY, c INT) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(0,0);
INSERT INTO t2 VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(0,0);
执行语句
--0在最后
mysql> SELECT * FROM t1;+----+------+| id | c |+----+------+|1|1||2|2||3|3||4|4||5|5||6|6||7|7||8|8||9|9||0|0|+----+------+--0在最前
mysql> SELECT * FROM t2;+----+------+| id | c |+