Question

SQL如何将一个表中的某一条记录插入另一个表中

这是我要的那条记录
select * from py15
where p15_slipno='qfw120027-09' and p15_sation='5140' and p15_prdtcode='402I'

我备份到另一个表py15_27_09 中
select * into py15_27_09
from py15 where p15_slipno='qfw120027-09' and p15_prdtcode='402I'

我在py15中删除了这个记录
delete py15 where p15_slipno='qfw120027-09' and p15_prdtcode='402I'

现在想恢复那条记录
insert into py15 select p15_slipno='qfw120027-09' and p15_prdtcode='402I' f
rom py15_27_09

我执行恢复那条命令提示and附近语法错误，错在哪里？

Answer 1

直接用下面的语句（假设我要把A表中字段姓名是‘张三’的记录插入B表）：

Insert Into B(B.姓名,B.准考证号,B.得分,B.考试时间,B.科目) select A.姓名,A.准考证号,A.得分,A.考试时间,'计算机二级' from A where A.姓名='张三';

Answer 2

insert into py15(p15_slipno,p15_prdtcode)
select p15_slipno,p15_prdtcode from py15_27_09
where p15_slipno ='qfw120027-09'
and p15_prdtcode ='402I'

追问

谢谢.我这样操作效果一样吗

insert into py15
select *
from py15_27_09
where p15_slipno='qfw120027-09' and p15_prdtcode='402I'