下面是在mysql 查询浏览器里写存储过程和调试,步子为:在数据库上右键选择create new procedure / function,输入一个名称,我这里输入的是"bbb",它会自动创建一个空的过程模板,我声明了三个变量,给三个变量赋值,并输出三个变量,在查询 浏览器菜单 tools -> mysql command line client 直接进DOS窗口,先use databasename;call procedurename();可以带参数,我这里没用参数。
----------------------------------------------------------------------------------------------------------
DELIMITER $$
DROP PROCEDURE IF EXISTS `test`.`bbb`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `test`.`bbb`()
BEGIN
declare a int;
declare b varchar(45);
declare c varchar(45);
set a = 3;
set b = "abc";
select strname from t1 into c;
select a;
select b;
select c;
END $$
DELIMITER ;
------------------------------------------------------------------------------------------------------------
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 2
Server version: 5.1.30-community MySQL Community Server (GPL)
Type 'help;' or '/h' for help. Type '/c' to clear the buffer.
mysql> use test;
Database changed
mysql> call bbb();
+------+
| a |
+------+
| 3 |
+------+
1 row in set (0.02 sec)
+------+
| b |
+------+
| abc |
+------+
1 row in set (0.03 sec)
+-------------+
| c |
+-------------+
| test string |
+-------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.05 sec)
mysql>
-------------------------------------------------------------------------------------------------------
感觉csdn还没有百度专业,在那里可以贴抓图,我在百度也有博客一般都附了抓图
如果觉得《在mysql中创建和调试存储过程》对你有帮助,请点赞、收藏,并留下你的观点哦!