摘要:
1、eg: SELECT u.rank FROM ( SELECT zc.fk_user_id,es.shop_type,(@ranknum:=@ranknum+1) AS rank FROM zsm_credit zc LEFT JOIN es_shop es ON zc.fk_user_id = 阅读全文
摘要:
Mysql中实现行转列或者实现以下操作的实现: 使用max()函数与case......when........then.......else......end实现 eg: 表A select year , max(case month when '1' then amount else 0 end 阅读全文