insert into A (ID,name,age,score,classes) select (select max(cast(ID as signed integer))+1 from A) ,'tom',21,score,classes from A WHERE ID=1017;
—varchar 转 int
cast(id as signed integer) 或者 cast(id as unsigned integer)
insert into A (ID,name,age,score,classes) select (select max(cast(ID as signed integer))+1 from A) ,'tom',21,score,classes from A WHERE ID=1017;
—varchar 转 int
cast(id as signed integer) 或者 cast(id as unsigned integer)