1.把这张表exnet_cardnumbers中的没用的数据移到exnet_cardnumbers_old表里面去,所有字段都移过去的写法:
insert into exnet_cardnumbers_old select * from exnet_cardnumbers where Id='1660003';
1.把这张表exnet_cardnumbers中的没用的数据移到exnet_cardnumbers_old表里面去,只移动部分字段CardId,`PASSWORD`:
insert into exnet_cardnumbers_old (CardId,`PASSWORD`) select CardId,`Password` from exnet_cardnumbers where Id='1660003';