mysql 分页

DELIMITER $DROP PROCEDURE IF EXISTS `test`.`sp_test`$CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_test`(IN table_name VARCHAR(255), IN page_begin INT,IN page_end INT)BEGIN SET @stmt = CONCAT('select * from ',table_name,' limit ?,?'); PREPARE s1 FROM @stmt; SET @s1 = page_begin; SET @s2 = page_end; EXECUTE s1 USING @s1,@s2; DEALLOCATE PREPARE s1;END$DELIMITER ;CALL sp_test('chart_data',10,20) 

Mysql 动态分页