不知道有比较好的方法没,这样也可以:
create table tmp select * from test1 where id='0002';
alter table tmp drop column id;
insert into test1 select '0004',tmp.* from tmp;
drop table tmp;
create table tmp select * from test1 where id='0002';
alter table tmp drop column id;
insert into test1 select '0004',tmp.* from tmp;
drop table tmp;
for i=1 to n
insert table1 select * from table1 where name='john'最后再点上ID字段,还是设成自动增量字段(标识=True)