Mysql自动增值键初值设定

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