MySQL 分页

/*
**创建临时表tempUser
*/
DROP TEMPORARY TABLE IF EXISTS tempUser;
CREATE TEMPORARY TABLE tempUser
(
    FIndex INT PRIMARY KEY AUTO_INCREMENT,
    FID INT,
    FName VARCHAR(40),
    FCompanyID INT
)ENGINE = MEMORY;
/*插入数据到临时表*/
INSERT INTO tempUser(FID,FName,FCompanyID)
SELECT FID,FAccount,FCompanyID
FROM tusers
WHERE FCompanyID=36052;


/*
**分页
*/
SET @pageIndex= 2;
SET @pageSize= 20;

SET @skip= ((@pageIndex-1)*@pageSize)+1;
SET @take= (@pageIndex * @pageSize);

SELECT * FROM tempUser
WHERE FIndex BETWEEN @skip AND @take;

/*清理临时表*/
DROP TABLE tempUser