Stored Procedure Syntax CREATEPROCEDUREprocedure_name AS sql_statement GO; Execute a Stored Procedure EXECprocedure_name; Demo Database Below is a selection from the "Customers" table in the Northwind sample dat
让我们使用 MySQL 命令提示符在 TEST 数据库中创建这个存储过程 −实例 DELIMITER $$ DROP PROCEDURE IF EXISTS 'TEST'.'getRecord' $$ CREATE PROCEDURE 'TEST'.'getRecord' ( IN in_id INTEGER, OUT out_name VARCHAR(20), OUT out_age INTEGER) BEGIN SELECT name, age INTO out_name, out_age ...