--创建
CREATE PROCEDURE pro_name(IN inputName inputType, OUT outputName outputType)
BEGIN
--sql statement...
SELECT ** INTO outputName FROM ** WHERE **
SET outputName = newValue;
END
--调用
set @inputName=value1;
set @outputName=value2;
CALL pro_name(@inputName,@outputName);
--删除
DROP PROCEDURE pro_name;
参数类型:
IN:输入参数
OUT:输出参数
INOUT:既可以输入/输出
2、触发器
CREATE TRIGGER AFTER INSERT/UPDATE/DELETE ON table1 FOR EACH ROW
INSERT INTO tables(...) VALUES(...);