sql
v_wanglei
乐于分享
展开
-
UPDATE之表数据修改
直接看SQL:-- 同步某表数据 2020年11月7日17:15:36UPDATE lb_order o, ( SELECT IFNULL(SUM(g.cost_price),0) cost_price, ogl.order_sn FROM lb_order_goods_list ogl LEFT JOIN lb_goods g ON g.id = ogl.goods_id GROUP BY ogl.order_sn ) bSET o.cost_price_t原创 2020-11-07 17:16:21 · 790 阅读 · 0 评论 -
MYSQL之时间戳区间查询的那些坑
直接看SQL:SELECT `a`.*, `gs`.`market_price`, `gs`.`shop_price`, IF( q.q_id IS NULL, 'false', 'true') message_notifyFROM `lb_goods_activity_details` `a`LEFT JOIN `lb_goods_sku` `gs` ON `gs`.`sku_id` = `a`.`sku_id`LEFT JOIN `lb_goods_activity`原创 2020-08-29 15:58:15 · 1250 阅读 · 1 评论 -
关于MYSQL之IFNULL的那些坑
废话不多说,直接看SQL:UPDATE lb_user uSET u.user_level = ( SELECT IFNULL(levelid, u.user_level) FROM lb_user_level WHERE `status` = 1 AND levelid > u.user_level AND (upgrade_score < u.empirical OR upgrade_total_money < u.tota...原创 2020-08-14 11:19:11 · 3586 阅读 · 1 评论 -
关于UPDATE的那些坑
废话不多说,请看代码:UPDATE my_return SET next_settlement_time = date_sub(r_return_day,interval -1 day)WHERE r_id IN ( SELECT r.r_id FROM my_borrow_apply b LEFT JOIN my_return r ON r.b_id=b.b_id WH...原创 2018-07-04 14:42:51 · 552 阅读 · 0 评论