创建并调用了一个名为`liangzi`的MySQL存储过程，该过程根据传入的整数`i`执行不同的查询。当`i`等于1或2时，输出数字并提前结束，同时显示'BBS'；当`i`大于2时，输出数字，两次显示'BBS'，最后显示'BLOG.51CTO.COM'。示例中展示了调用过程的输出结果。
DELIMITER $$
USE `test`$$
DROP PROCEDURE IF EXISTS `liangzi`$$
CREATE DEFINER=`admin`@`%` PROCEDURE `liangzi`(IN i INT)
xiaoliangzi:BEGIN
IF i=1 THEN
SELECT 1;
LEAVE xiaoliangzi;
SELECT 'BBS';
ELSEIF i=2 THEN
SELECT 2;
LEAVE xiaoliangzi;
SELECT 'BBS';
ELSE
SELECT 3;
SELECT 'BBS';
END IF;
SELECT 'BLOG.51CTO.COM';
END$$
DELIMITER ;
-- ------------------------------------------
mysql> call liangzi(2);
+---+
| 2 |
+---+
| 2 |
+---+
1 row in set (0.00 sec)
-- ------------------------------------------
mysql> call liangzi(3);
+---+
| 3 |
+---+
| 3 |
+---+
1 row in set (0.00 sec)
+-----+
| BBS |
+-----+
| BBS |
+-----+
1 row in set (0.00 sec)
+----------------+
| BLOG.51CTO.COM |
+----------------+
| BLOG.51CTO.COM |
+----------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
-- ------------------------------------------
mysql> call liangzi(4);
+---+
| 3 |
+---+
| 3 |
+---+
1 row in set (0.00 sec)
+-----+
| BBS |
+-----+
| BBS |
+-----+
1 row in set (0.00 sec)
+----------------+
| BLOG.51CTO.COM |
+----------------+
| BLOG.51CTO.COM |
+----------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
278
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
