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'