56,687
社区成员
发帖
与我相关
我的任务
分享
mysql> CREATE PROCEDURE curdemo1(IN V_SQL CHAR(100))
-> BEGIN
->
-> set @s=V_SQL;
-> PREPARE stmt1 FROM @s;
-> EXECUTE stmt1 ;
-> DEALLOCATE PREPARE stmt1;
-> select FOUND_ROWS();
-> END
-> //
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> delimiter ;
mysql> call curdemo1('select * from student');
+----------+--------+------+------+---------+-------------+-------+-
| id | name | sex | age | address | phone | bedid |
+----------+--------+------+------+---------+-------------+-------+-
| 91010101 | 丁乙甲 | 男 | 21 | 通化 | 13900000000 | 111 |
| 91010102 | 索春龙 | 男 | 22 | 安徽 | 13910000000 | 0 |
| 91010103 | 刘莉莉 | 女 | 22 | 白城 | 13920000000 | 0 |
| 91010104 | 隋鑫 | 女 | 22 | 松原 | 13930000000 | 0 |
| 91010105 | 长命 | 男 | 22 | 地府 | 12222222222 | 0 |
| 91010201 | 河江山 | 男 | 20 | 陕西 | 13800000000 | 0 |
| 91010202 | 祝立业 | 男 | 20 | 长春 | 13800000000 | 0 |
....
| 91030201 | 王飞 | 男 | 22 | 永安 | 13730060000 | 0 |
+----------+--------+------+------+---------+-------------+-------+-
24 rows in set (0.00 sec)
+--------------+
| FOUND_ROWS() |
+--------------+
| 24 |
+--------------+
1 row in set (0.06 sec)
Query OK, 0 rows affected (0.06 sec)
mysql>