mysql> create table lse123_test (id integer auto_increment primary key);
Query OK, 0 rows affected (0.03 sec)

mysql> insert into lse123_test values (default), (default), (default), (default), (default), (default);
Query OK, 6 rows affected (0.00 sec)
Records: 6  Duplicates: 0  Warnings: 0

mysql> select * from lse123_test;
+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
|  4 |
|  5 |
|  6 |
+----+
6 rows in set (0.03 sec)

mysql> delete from lse123_test where id = 3;
Query OK, 1 row affected (0.02 sec)

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from lse123_test;
+----+
| id |
+----+
|  1 |
|  2 |
|  4 |
|  5 |
|  6 |
+----+
5 rows in set (0.00 sec)

mysql>