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_type = f.type
where p.member_id = 7416
AND p.merchant_num = 1900104
AND p.asset_type = 2
AND p.status = 1
/*修改会员等级*/
改t_member_propertys表的asset_id

 

数据，表结构同步

 

 

 

 

 

 

聚合函数  min max  avg  sum count