mySql存储过程的结构
mySql存储过程的结构
无参数的存储过程?
1 2 3 4 5 6 7 | CREATE PROCEDURE P_XSRBB() BEGIN DECLARE VP1 VARCHAR(20); SET VP1=4; SELECT VP1 FROM DUAL; END; CALL P_XSRBB(); |
带输入参数的存储过程
?
1 2 3 4 5 6 7 8 | 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); |