--source include/have_innodb.inc create table t1 (c2 int as (1+1), c1 int primary key auto_increment) engine=innodb; insert into t1(c1) values (null),(null),(null); select * from t1; alter table t1 auto_increment = 3; show create table t1; drop table t1;