SELECT
*
FROM
(
SELECT
@rownum :=@rownum + 1 AS rownum,
t_user.C_CRT_CDE
FROM
(SELECT @rownum := 0) a,
t_user
) b
*
FROM
(
SELECT
@rownum :=@rownum + 1 AS rownum,
t_user.C_CRT_CDE
FROM
(SELECT @rownum := 0) a,
t_user
) b
LIMIT 0,2
可实现分页查询。