gezipml的博客

tableA id uid invite_uid 1 11 204 2 12 204 tableB id uid money 1 204 10 2 204 10 执行SQL语句select sum(b.money) as moneyfrom tableB b join tableA a on a.invite_uid = b.uid group by a.invit...

今天在处理删除购物车表中商品ID不存在商品表的数据时MySQL报错 1093原SQL：update ims_member_cartset deleted=1 where id in ( select id from ims_member_cart WHERE goodsid not in(SELECT id from ims_goods )...