在同一数据库下,将表S_KAOQIN_RECORD中的id号,和CARDID这一列数据插入到S_KAOQIN_RECORD表对应字段PKID,CARDID
insert into S_KAOQINKA (PKID,CARDID) select PKID,CARDID from S_KAOQIN_RECORD
在同一数据库下,将表S_KAOQIN_RECORD中的id号,和CARDID这一列数据插入到S_KAOQIN_RECORD表对应字段PKID,CARDID
insert into S_KAOQINKA (PKID,CARDID) select PKID,CARDID from S_KAOQIN_RECORD