当前位置:Gxlcms > 数据库问题 > mysql

mysql

时间:2021-07-01 10:21:17 帮助过:2人阅读

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

标签:

人气教程排行