mysql> select version();

+-------------------------+

| version()               |

+-------------------------+

| 10.0.7-MariaDB-1~wheezy |

+-------------------------+

1 row in set (0.00 sec)

mysql>

mysql> CREATE TABLE test(

    -> id int(10)unsigned NOT NULL AUTO_INCREMENT,

    -> duma varchar(255)NOT NULL,

    -> PRIMARY KEY(id)

    -> )ENGINE=InnoDB DEFAULT CHARSET=utf8;

Query OK, 0 rows affected (0.01 sec)

mysql>

mysql> INSERT INTO test(id,duma)VALUES(1,'aaa'),(2,'bbb');

Query OK, 2 rows affected (0.00 sec)

Records: 2  Duplicates: 0  Warnings: 0

mysql>

mysql> ALTER TABLE test AUTO_INCREMENT=1;

Query OK, 0 rows affected (0.01 sec)

Records: 0  Duplicates: 0  Warnings: 0

mysql>

mysql> INSERT INTO test(duma)VALUES('ccc');

ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY'

mysql>