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; c2 c1 2 1 2 2 2 3 alter table t1 auto_increment = 3; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `c2` int(11) GENERATED ALWAYS AS (1 + 1) VIRTUAL, `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1;