随笔分类 -  sql

摘要:2、查询会员等级/*查询会员等级名称*/select * from enbrands_1900104.t_features f left join enbrands_1900104.t_member_propertys p on p.asset_id = f.`order` and p.asset_ 阅读全文
posted @ 2022-03-23 17:20 aprial01 阅读(41) 评论(0) 推荐(0)
摘要:1. 2个表关联查询后把A表的ouid填写到B表的out_member_id UPDATE t_members m JOIN t_member_merchant_bind b ON m.id = b.member_id SET m.out_member_id = b.ouid WHERE b.mer 阅读全文
posted @ 2021-12-09 10:50 aprial01 阅读(139) 评论(0) 推荐(0)