1、打开Xshell，连接服务器并登陆到服务器，输入连接到MySQL
2、创建测试表，并指定字段为auto_increment，如下图所示create table test( id int not null auto_increment primary key, name varchar(10));
4、可以使用并通过alter table test auto_incremenrt=n语句来强制设置自动增长列的初始值。例如使用如下语句强制设置自增长初始值alter table test auto_incremenrt=4;insert into test values(null,'guanyu');
6、一个表嘀芟苒疾有且只能有一个auto_increment属性,自增长列必须是索引5.如果表中的auto_increment最大值被删除，不会被重用。即会巳鹞届蟑跳号mysql> select * from test;+----+------------+| id | name |+----+------------+| 1 | zhanghui || 2 | liubei || 3 | guanyu || 5 | shjhsdshjd |+----+------------+4 rows in set (0.00 sec)mysql> delete from test where id=5;Query OK, 1 row affected (0.01 sec)mysql>mysql> insert into test values(null,'machao');Query OK, 1 row affected (0.01 sec)mysql> select * from test;+----+----------+| id | name |+----+----------+| 1 | zhanghui || 2 | liubei || 3 | guanyu || 6 | machao |+----+----------+4 rows in set (0.00 sec)
