mysql触发器传入参数

SET @my_variable = 'some_value';

DELIMITER $$
CREATE TRIGGER my_trigger
AFTER INSERT ON my_table
FOR EACH ROW
BEGIN
    -- 在这里使用@my_variable
END$$
DELIMITER ;

DELIMITER $$
CREATE TRIGGER my_trigger
BEFORE INSERT ON my_table
FOR EACH ROW
BEGIN
    -- 使用NEW或OLD关键字访问插入或更新的记录字段
    SET NEW.some_field = UPPER(NEW.some_field);
END$$
DELIMITER ;

-- 创建辅助表
CREATE TABLE trigger_params (
    param_name VARCHAR(255),
    param_value VARCHAR(255)
);

-- 插入参数
INSERT INTO trigger_params (param_name, param_value) VALUES ('my_param', 'some_value');

DELIMITER $$
CREATE TRIGGER my_trigger
BEFORE INSERT ON my_table
FOR EACH ROW
BEGIN
    DECLARE my_param_value VARCHAR(255);
    -- 查询辅助表获取参数值
    SELECT param_value INTO my_param_value FROM trigger_params WHERE param_name = 'my_param';
    -- 在这里使用my_param_value
END$$
DELIMITER ;