INSERT INTO table1 (table1_field1,table1_field2,...) select table2_filed1,table2_field2,... from table2 where condition1 and condition2 ...;
//一张表符合条件的数据插入另一张表对应字段中
insert into shelve_goods_info(product_id,`name`,image,original_amount,amount,spec_id,spec_str,sync_time,last_updtime) select DISTINCT product_id,`name`,image,original_amount,amount,spec_id,spec_str,sync_time,NOW() from jingguo_order_goods group by product_id order by sync_time desc;
//根据一张表的数据修改另一张表的数据
update shelve_goods_info as s,tt as t set s.print_title=t.newname, s.price=t.newprice, original_price=Ceil(t.newprice*10/8) where s.name=t.orname;
————————————————
版权声明:本文为优快云博主「one312」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.youkuaiyun.com/one312/article/details/79350363