mysql 触发器里支持动态sql

DELIMITER //

CREATE PROCEDURE DynamicSQLProc(IN tableName VARCHAR(64), IN action VARCHAR(64))
BEGIN
    DECLARE sqlQuery VARCHAR(512);
    
    SET sqlQuery = CONCAT('SELECT * FROM ', tableName);
    
    IF action = 'INSERT' THEN
        SET sqlQuery = CONCAT('INSERT INTO ', tableName, ' VALUES (1, ''test'')');
    ELSEIF action = 'UPDATE' THEN
        SET sqlQuery = CONCAT('UPDATE ', tableName, ' SET column1 = ''new_value'' WHERE id = 1');
    ELSEIF action = 'DELETE' THEN
        SET sqlQuery = CONCAT('DELETE FROM ', tableName, ' WHERE id = 1');
    END IF;
    
    PREPARE stmt FROM sqlQuery;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;
END //

DELIMITER ;

DELIMITER //

CREATE TRIGGER my_trigger
AFTER INSERT ON my_table
FOR EACH ROW
BEGIN
    CALL DynamicSQLProc('my_table', 'INSERT');
END //

DELIMITER ;