mysql

INSERT INTO `weixin_commonshop_orders_payway_detail` ( `id` , `total` )
SELECT b.`id` , b.`totalprice` FROM `weixin_commonshop_orders` AS b WHERE
b.`id` NOT IN ( SELECT c.`id` FROM `weixin_commonshop_orders_payway_detail`
as c ) 

转存

mysql

标签：