触发器中的MYSQL错误如何解决？

tail -f /var/log/mysql/error.log

SHOW TRIGGERS LIKE 'your_trigger_name';

DELIMITER $$
CREATE TRIGGER your_trigger_name
AFTER INSERT ON your_table
FOR EACH ROW
BEGIN
    DECLARE error_message VARCHAR(255);
    SET error_message = CONCAT('Debug info: ', NEW.column_name);
    SELECT error_message;
END$$
DELIMITER ;

SHOW GRANTS FOR 'your_user'@'your_host';

DELIMITER $$
CREATE PROCEDURE test_trigger()
BEGIN
    -- 插入测试数据
    INSERT INTO your_table (column_name) VALUES ('test_value');
    
    -- 检查结果
    SELECT * FROM your_table WHERE column_name = 'test_value';
END$$
DELIMITER ;

DELIMITER $$
CREATE TRIGGER your_trigger_name
AFTER INSERT ON your_table
FOR EACH ROW
BEGIN
    -- 第一步
    INSERT INTO debug_table (message) VALUES ('Step 1');
    
    -- 第二步
    UPDATE another_table SET column = NEW.column_name WHERE id = NEW.id;
    
    -- 第三步
    INSERT INTO debug_table (message) VALUES ('Step 2');
END$$
DELIMITER ;

DELIMITER $$
CREATE TRIGGER audit_trigger
AFTER INSERT ON employees
FOR EACH ROW
BEGIN
    INSERT INTO audit_log (employee_id, action, timestamp)
    VALUES (NEW.id, 'INSERT', NOW());
END$$
DELIMITER ;