DDL:
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
SQL:
INSERT into user(name)VALUES('ee');
SELECT * from user;ALTER table `user` auto_increment = 1000;
Result:
id name
------------------------------
1 ee
2 ee
3 ee
4 ee
5 ee
6 ee
7 ee
8 ee
9 ee
1000 ee