标签：MYSQL 统计一个班有多少个学生

MYSQL 统计一个班有多少个学生

复制 create temporary table classname select 1 as cid, '小一班' as cid_name union all select 2, '小二班' union all select 3, ...