Thread: 复制本表的数据记录, 不复制表结构
View Single Post
  #1   IP: 49.87.116.189
Old 2014-11-24, 06:34 PM
Cedar Hill Cedar Hill is offline
初级会员
  
Join Date: 2012-03-08
Posts: 1
Cedar Hill 现在声名狼藉
Default 复制本表的数据记录, 不复制表结构
insert into shops(name,price,num,desn) select name, price,num,desn from shops;
Reply With Quote