将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