摘要:
select a.name, a.total_score,@rank:=@rank+1 as rank from ( select u.name,uti.total_score from user_total_integral uti left join tuser u on uti.user_id 阅读全文
摘要:
update groupuser as g1 join groupuser as g2 on (g1.user_id=1 and g2.user_id = 2) or(g1.user_id = 2 and g2.user_id=1) set g1.group_id = g2.group_id,g2.group_id=g1.group_id; 阅读全文