正在阅读：MySQL 5.0 新特性教程 存储过程:第二讲MySQL 5.0 新特性教程 存储过程:第二讲

CREATE PROCEDURE p1 ()
CREATE PROCEDURE p2 () DELETE FROM t; //

CREATE PROCEDURE, ALTER PROCEDURE, DROP PROCEDURE, CREATE FUNCTION,
DROP FUNCTION, CREATE TRIGGER, DROP TRIGGER.

CREATE PROCEDURE db5.p1 () DROP DATABASE db5//

"USE database"

mysql> CALL p1() //
+------+
| s1 |
+------+
| 5 |
+------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)

"SELECT * FROM t;"