mysql 支持带参数的游标吗?
解决方案 »
- mysql最优分区
- 如何将一个表中的两个字段内容合并
- (在线等)大牛帮忙写一个存储过程好么(主要是对语法不熟)
- 把A表部分数据拷贝到B表
- select for update
- 很奇怪的问题,大家帮忙分析下什么原因啊,分数有限大家谅解啊
- java 写入 mysql5.0数据库乱码问题,请求解决,情况如下
- into outfile让我发疯!
- 初次安装的问题
- 请问如何才能把图片保存到mysql中
- instr 这个函数怎么连null也能匹配到?
- select timestampdiff(month ,'2009-05-31 23:08:10','2009-06-01 09:03:52');为什么===0
SELECT
b.COLUMN_SOURCE,
b.COLUMN_NAME,
b.COLUMN_MEANS,
b.OPERATOR,
b.VALUE
FROM bi_rules b
WHERE b.RULE_GROUP = V_GROUP;
mysql>
mysql> CREATE PROCEDURE curdemo(IN V_GROUP INT)
-> BEGIN
-> DECLARE done INT DEFAULT 0;
-> DECLARE a INT;
-> DECLARE b CHAR(16);
->
-> DECLARE cur1 CURSOR FOR SELECT id,name FROM student where classid=V_GROUP;
-> DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
->
-> OPEN cur1;
->
-> REPEAT
-> FETCH cur1 INTO a, b;
-> select a,b;
-> UNTIL done END REPEAT;
->
-> CLOSE cur1;
-> END
->
->
-> //
Query OK, 0 rows affected (0.20 sec)mysql>
mysql> delimiter ;
mysql>
mysql> SELECT id,name,classid FROM student ;
+----------+--------+---------+
| id | name | classid |
+----------+--------+---------+
| 91010101 | 丁乙甲 | 10101 |
| 91010102 | 索春龙 | 10101 |
| 91010103 | 刘莉莉 | 10101 |
| 91010104 | 隋鑫 | 10101 |
| 91010105 | 长命 | 10101 |
| 91010201 | 河江山 | 10102 |
| 91010202 | 祝立业 | 10102 |
| 91010203 | 姚桂娇 | 10102 |
| 91010204 | 张冬梅 | 10102 |
| 91020101 | 蒋旭 | 10201 |
| 91020102 | 邱介臣 | 10201 |
| 91020103 | 王晓燕 | 10201 |
| 91020104 | 夏丽佳 | 10201 |
| 91020201 | 熊建业 | 10202 |
| 91020202 | 丛俊江 | 10202 |
| 91020203 | 周静燕 | 10202 |
| 91020204 | 黄爽 | 10202 |
| 91020301 | 魏国兴 | 10203 |
| 91020302 | 蒋洪涛 | 10203 |
| 91020303 | 倪春红 | 10203 |
| 91030101 | 张文天 | 10301 |
| 91030102 | 姜洋 | 10301 |
| 91030103 | 赵聪 | 10301 |
| 91030201 | 王飞 | 10302 |
+----------+--------+---------+
24 rows in set (0.00 sec)mysql>
mysql> CALL curdemo(10101);
+----------+--------+
| a | b |
+----------+--------+
| 91010101 | 丁乙甲 |
+----------+--------+
1 row in set (0.00 sec)+----------+--------+
| a | b |
+----------+--------+
| 91010102 | 索春龙 |
+----------+--------+
1 row in set (0.00 sec)+----------+--------+
| a | b |
+----------+--------+
| 91010103 | 刘莉莉 |
+----------+--------+
1 row in set (0.00 sec)+----------+------+
| a | b |
+----------+------+
| 91010104 | 隋鑫 |
+----------+------+
1 row in set (0.00 sec)+----------+------+
| a | b |
+----------+------+
| 91010105 | 长命 |
+----------+------+
1 row in set (0.00 sec)+----------+------+
| a | b |
+----------+------+
| 91010105 | 长命 |
+----------+------+
1 row in set (0.00 sec)Query OK, 0 rows affected (0.00 sec)mysql>
open cur_condition(V_GROUP) 这种情况在mysql里面不支持的,而要实现类似的功能,只能通过楼上间接采用存储过程的方式进行转换。