Home >Database >Mysql Tutorial >mySql存储过程的结构_MySQL
mySql存储过程的结构_MySQL
- WBOYOriginal
- 2016-06-01 13:18:261005browse
bitsCN.com
无参数的存储过程
CREATE PROCEDURE P_XSRBB()BEGIN DECLARE VP1 VARCHAR(20); SET VP1=4;SELECT VP1 FROM DUAL;END;CALL P_XSRBB();带输入参数的存储过程
DROP PROCEDURE IF EXISTS P_XSRBB;CREATE PROCEDURE P_XSRBB(in vp2 INT)BEGIN DECLARE VP1 VARCHAR(20); SET VP1=4;SELECT VP2 FROM DUAL;END;CALL P_XSRBB(3434);bitsCN.com
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL安装、配置、使用及JDBC链接_MySQLNext article：MySQL模拟PostgreSQLgenerate_series表函数_MySQL