mysql数据库新建一个递增的_MySQL对字段新增自增序列

现在有这样的场景，我们的数据库类型是MySQL，表是从其他库拿过来的，约束和索引都没迁移。现在希望增加一个自增序列。

且自增序列是从当前最大自增ID开始的，下面就是这样一个过程的演示。

mysql> create table t_test1(id int,name varchar(1000));

Query OK, 0 rows affected (0.12 sec)

# 修改id字段为主键字段，且自增

mysql> alter table t_test1 modify id int primary key auto_increment ;

Query OK, 0 rows affected (0.06 sec)

Records: 0 Duplicates: 0 Warnings: 0

# 插入数据，自动填充id

mysql> insert into t_test1(name) values('xiaoming');

Query OK, 1 row affected (0.00 sec)

mysql> select * from t_test1;

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

| id | name |

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

| 1 | xiaoming |

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

1 row in set (0.00 sec)

# 修改t_test1 表的自增起始值

mysql> alter table t_test1 auto_increment = 1000;

Query OK, 0 rows affected (0.00 sec)

Records: 0 Duplicates: 0 Warnings: 0

mysql> insert into t_test1(name) values('xiaoming');

Query OK, 1 row affected (0.01 sec)

# 自增序列从起始值开始

mysql> select * from t_test1;

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

| id | name |

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

| 1 | xiaoming |

| 1000 | xiaoming |

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

2 rows in set (0.00 sec)