一楼的方法已经很直接了 create table temp1(a int not null auto_increment primary key,b int); insert into temp1(b) select 1; insert into temp1(b) select b from temp1; insert into temp1(b) select b from temp1; insert into temp1(b) select b from temp1; insert into temp1(b) select b from temp1; insert into temp1(b) select b from temp1; insert into temp1(b) select b from temp1; insert into temp1(b) select b from temp1;
create table temp1(a int not null auto_increment primary key,b int);
insert into temp1(b) select 1;
insert into temp1(b) select b from temp1;
insert into temp1(b) select b from temp1;
insert into temp1(b) select b from temp1;
insert into temp1(b) select b from temp1;
insert into temp1(b) select b from temp1;
insert into temp1(b) select b from temp1;
insert into temp1(b) select b from temp1;