MySQL stored procedure definition and invocation

#MySQL存储过程 # #最简单的存储过程DROP PROCEDURE IF EXISTSSP1;CREATE PROCEDURESP1 () COMMENT'The simplest stored procedure'     SELECT 1; # #调用CALL SP1 (); # #带输入参数的存储过程DROP PROCEDURE IF EXISTSSP2;CREATE PROCEDURESP2 (inchPINT) COMMENT'stored procedure with input parameters'    SELECTp;# #调用CALL SP2 (1); #带输出参数的存储过程DROP PROCEDURE IF EXISTSSP3;CREATE PROCEDURESP3 (out QINT) COMMENT'stored procedure with output parameters'    SELECT 1  intoq; #调用CALL SP3 (@r);SELECT @r; #带输入和输出参数的存储过程DROP PROCEDURE IF EXISTSSP4;CREATE PROCEDURESP4 (inchPINT, Out QINT) COMMENT'stored procedures with input and output parameters'    SELECTP intoq; #调用CALL SP4 (1,@r);SELECT @r;

MySQL stored procedure definition and invocation