不同表之间的字段值进行复制的sql语句

ecs_goods表中的goods_id,goods_img,goods_thumb,original_img这四个字段的值复制到ecs_goods_gallery表中的goods_id,img_url,thumb_url,img_original这四个字段中,按照顺序一一对应:

insert into ecs_goods_gallery (goods_id,img_url,thumb_url,img_original) select goods_id,goods_img,goods_thumb,original_img from ecs_goods

如果要加个条件,从goods_id=1000时才开始复制:

insert into ecs_goods_gallery (goods_id,img_url,thumb_url,img_original) select goods_id,goods_img,goods_thumb,original_img from ecs_goods where goods_id >= 1000