mysql动态排序，增加自动排序栏位NO,行转列

limit 动态排序
set @num= (select count(*) from contest_table_32);
set @ll =  (select CEILING((@num*0.3)));
SET @stmt = CONCAT('select * from contest_table_32 limit ',0,',',@ll,'');
PREPARE r FROM @stmt;
EXECUTE r

mysql增加自动排序栏位NO
SELECT
,examid,
,examname,
,examnumber,
,(@i :=@i + 1) AS No
FROM
,exammanager,
,(SELECT @i := 0) AS it
ORDER BY examnumber

行转列
select areacode,schoolid,PeriodID,schoolname,grade,ClassID,ClassName,ifnull(MAX(CASE WHEN  usertype=1 THEN jingsainumber END),0) as stuNum ,ifnull(MAX(CASE WHEN usertype=2 THEN jingsainumber END),0) as teaNum ,
 ifnull(MAX(CASE WHEN usertype=4 THEN jingsainumber END),0) as parNum from tmp_table_allA GROUP BY ClassID