![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
gezipml
这个作者很懒,什么都没留下…
展开
-
MYSQL JOIN查询数据出现重复问题的解决
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...原创 2021-01-29 16:40:53 · 3576 阅读 · 0 评论 -
MySQL执行update时的[ERROR 1093]处理方法
今天在处理删除购物车表中商品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 )...原创 2018-08-20 14:01:34 · 1077 阅读 · 0 评论