lzx2766478的博客

学生成绩排行建立表语句CREATE TABLE `student` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, `score` int(11) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;查询全部select * from stud

select * from static_log;select name,count(count_nu) from (select `name`,count_nu, case when count_nu >0 then (@c := @c + 1) end as zz, case when count_nu < 0 then (@b + @c) end as cc from st...