innodb和myisam表排序

myisam表:

mysql> show create table p200\G;
*************************** 1. row ***************************
       Table: p200
Create Table: CREATE TABLE `p200` (
  `sn` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` char(32) NOT NULL,
  `mobilePhone` char(11) NOT NULL,
  PRIMARY KEY (`sn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

ERROR: 
No query specified

mysql> insert into p200(uuid,mobilePhone) values(5,300);
Query OK, 1 row affected (0.02 sec)

mysql> insert into p200(uuid,mobilePhone) values(1,300);
Query OK, 1 row affected (0.01 sec)

mysql> insert into p200(uuid,mobilePhone) values(30,300);
Query OK, 1 row affected (0.00 sec)

mysql> insert into p200(uuid,mobilePhone) values(18,300);
Query OK, 1 row affected (0.00 sec)

mysql> select * from p200;
+----+------+-------------+
| sn | uuid | mobilePhone |
+----+------+-------------+
|  1 | 5    | 300         |
|  2 | 1    | 300         |
|  3 | 30   | 300         |
|  4 | 18   | 300         |
+----+------+-------------+
4 rows in set (0.00 sec)

mysql> insert into p200(sn,uuid,mobilePhone) values(30,18,300);
Query OK, 1 row affected (0.00 sec)

mysql> insert into p200(sn,uuid,mobilePhone) values(5,18,300);
Query OK, 1 row affected (0.00 sec)

mysql> select * from p200;
+----+------+-------------+
| sn | uuid | mobilePhone |
+----+------+-------------+
|  1 | 5    | 300         |
|  2 | 1    | 300         |
|  3 | 30   | 300         |
|  4 | 18   | 300         |
| 30 | 18   | 300         |
|  5 | 18   | 300         |
+----+------+-------------+
6 rows in set (0.00 sec)


innodb表:
mysql> show create table p100\G;
*************************** 1. row ***************************
       Table: p100
Create Table: CREATE TABLE `p100` (
  `sn` int(11) NOT NULL AUTO_INCREMENT,
  `uuid` char(32) NOT NULL,
  `mobilePhone` char(11) NOT NULL,
  PRIMARY KEY (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

ERROR: 
No query specified

mysql> insert into p100(uuid,mobilePhone) values(10,1);
Query OK, 1 row affected (0.05 sec)

mysql> insert into p100(uuid,mobilePhone) values(3,100);
Query OK, 1 row affected (0.00 sec)

mysql> insert into p100(uuid,mobilePhone) values(7,200);
Query OK, 1 row affected (0.01 sec)

mysql> insert into p100(uuid,mobilePhone) values(30,300);
Query OK, 1 row affected (0.01 sec)

mysql> select * from p100;
+----+------+-------------+
| sn | uuid | mobilePhone |
+----+------+-------------+
|  1 | 10   | 1           |
|  2 | 3    | 100         |
|  3 | 7    | 200         |
|  4 | 30   | 300         |
+----+------+-------------+
4 rows in set (0.00 sec)


mysql> insert into p100(sn,uuid,mobilePhone) values(10,18,300);
Query OK, 1 row affected (0.00 sec)

mysql> insert into p100(sn,uuid,mobilePhone) values(8,18,300);
Query OK, 1 row affected (0.00 sec)

mysql> insert into p100(sn,uuid,mobilePhone) values(30,18,300);
Query OK, 1 row affected (0.00 sec)

mysql> insert into p100(sn,uuid,mobilePhone) values(11,18,300);
Query OK, 1 row affected (0.00 sec)

mysql> select * from p100;
+----+------+-------------+
| sn | uuid | mobilePhone |
+----+------+-------------+
|  1 | 10   | 1           |
|  2 | 3    | 100         |
|  3 | 7    | 200         |
|  4 | 30   | 300         |
|  8 | 18   | 300         |
| 10 | 18   | 300         |
| 11 | 18   | 300         |
| 30 | 18   | 300         |
+----+------+-------------+
8 rows in set (0.00 sec)


InnoDB表插入顺序为主键顺序,myisam 顺序为插入的顺序排序