MySQL stored procedures

Parameters

• The value of the in parameter must be specified when the stored procedure is called, and the value of the parameter modified in the stored procedure cannot be returned as the default value.
• out : This value can be changed inside the stored procedure and can be returned.
• INOUT : Called when specified, and can be changed and returned.

#创建简单的存储过程查询

//  PROCEDURE Selectgood (VARCHAR ())       BEGIN      where ID    END;     // DELIMITER; #调用

CALL selectGood(‘10035‘)

MySQL stored procedures