MySQL の AUTO_INCREMENT の挙動確認

mysql> CREATE TABLE auto_increment_test (
    ->     `id`      INT UNSIGNED        NOT NULL AUTO_INCREMENT,
    ->     `data`    INT UNSIGNED        NOT NULL,
    ->     PRIMARY KEY (`id`)
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.02 sec)

mysql> INSERT `auto_increment_test` (`id`, `data`) VALUES (100, 1);
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM `auto_increment_test`;
+-----+------+
| id  | data |
+-----+------+
| 100 |    1 |
+-----+------+
1 row in set (0.00 sec)

mysql> INSERT `auto_increment_test` (`data`) VALUES (2);
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM `auto_increment_test`;
+-----+------+
| id  | data |
+-----+------+
| 100 |    1 |
| 101 |    2 |
+-----+------+
2 rows in set (0.00 sec)

mysql> INSERT `auto_increment_test` (`id`, `data`) VALUES (10, 3);
Query OK, 1 row affected (0.01 sec)

mysql> SELECT * FROM `auto_increment_test`;
+-----+------+
| id  | data |
+-----+------+
|  10 |    3 |
| 100 |    1 |
| 101 |    2 |
+-----+------+
3 rows in set (0.00 sec)

mysql> INSERT `auto_increment_test` (`data`) VALUES (4);
Query OK, 1 row affected (0.02 sec)

mysql> SELECT * FROM `auto_increment_test`;
+-----+------+
| id  | data |
+-----+------+
|  10 |    3 |
| 100 |    1 |
| 101 |    2 |
| 102 |    4 |
+-----+------+
4 rows in set (0.00 sec)

mysql> INSERT `auto_increment_test` (`id`, `data`) VALUES (10, 5);
ERROR 1062 (23000): Duplicate entry '10' for key 'PRIMARY'