MySQL 获取确定条数的数据,不足用null补全,用于固定栏位的报表。
SELECT
id,gradeNo
FROM
(
SELECT
id,gradeNo
FROM
base_grade t1
UNION all SELECT NULL,NULL FROM base_grade t3
UNION all SELECT NULL,NULL FROM base_grade t3
UNION all SELECT NULL,NULL FROM base_grade t3
UNION all SELECT NULL,NULL FROM base_grade t3
UNION all SELECT NULL,NULL FROM base_grade t3
) t2
LIMIT 5
返回结果: