解决方案 »
- 请教一个SQL查询语句
- MySQL存储过程,递归查询
- 求助 一个关联问题
- 关于存储过程select into 赋值的问题
- auto_increment_offset > auto_increment_increment 时会怎么样?
- mysql数据库的一个表最多能有多少列?
- 什么开发和mysql结合紧密,什么方式连接?
- 如图:安装Mysql时为什么会出现配置文件的模板:E:\MYSQL\my-template.ini 无法处理,并写入到E:\MYSQL\my.ini.中
- 求一条mysql语句 在线等 在线结贴
- 动态插入10条数据,如何插入
- 在存储过程中这样一个语句怎么写?
- MYSQL 二进制日志概念澄清
da ban zhu ne???
DELIMITER $$DROP PROCEDURE IF EXISTS `test`.`sp_test`$$CREATE PROCEDURE `test`.`sp_test`(IN table_name varchar(255),IN total int)
BEGIN
set @stmt = concat('select * from ',table_name,' limit ?');
prepare s1 from @stmt;
set @s = total;
execute s1 using @s;
deallocate prepare s1;
END$$DELIMITER ;调用:
call sp_test('表名',数量);
我后来采用临时表用between and解决了的
select * from test.song limit 10;
query result(10 records)
id name datetime rank
1 woshiduide1 2007-10-03 00:27:11 9
2 woshiduide2 2007-10-03 00:27:11 9
3 woshiduide3 2007-10-03 00:27:11 4
4 woshiduide4 2007-10-03 00:27:11 6
5 woshiduide5 2007-10-03 00:27:11 7
6 woshiduide6 2007-10-03 00:27:11 5
7 woshiduide7 2007-10-03 00:27:11 3
8 woshiduide8 2007-10-03 00:27:11 9
9 woshiduide9 2007-10-03 00:27:11 6
10 woshiduide10 2007-10-03 00:27:11 4 call sp_test('test.song',10);
query result(10 records)
id name datetime rank
1 woshiduide1 2007-10-03 00:27:11 9
2 woshiduide2 2007-10-03 00:27:11 9
3 woshiduide3 2007-10-03 00:27:11 4
4 woshiduide4 2007-10-03 00:27:11 6
5 woshiduide5 2007-10-03 00:27:11 7
6 woshiduide6 2007-10-03 00:27:11 5
7 woshiduide7 2007-10-03 00:27:11 3
8 woshiduide8 2007-10-03 00:27:11 9
9 woshiduide9 2007-10-03 00:27:11 6
10 woshiduide10 2007-10-03 00:27:11 4
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 ;select * from cs_test;
call sp_test('cs_test',2,3);
结果:
query result(9 records)
id name
1 csdn1
2 colorful1
3 bbs1
4 cu1
5 cu2
6 woshiduide\n\n\n\n\n
7 woshicuode
8 I'm wrong
9 I'm right
query result(3 records)
id name
3 bbs1
4 cu1
5 cu2