access 拷贝一行记录

Posted on 2017-12-06 10:52  KA卡尔特人头狼  阅读(223)  评论(0)    收藏  举报

方法一：
insert into table_1(ID) values(3);

update table_1 a,table_1 b set a.C1=b.C1,a.C2=b.C2,a.C3=b.C3 where a.ID=3 and b.ID=2;

方法2：

select * into tmp from table_1 where ID=1;

update tmp set ID=999;

insert into table_1 select * from tmp;

drop table tmp;