mysql存储过程写到日志中

CREATE TABLE IF NOT EXISTS procedure_logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    procedure_name VARCHAR(255) NOT NULL,
    execution_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    status VARCHAR(50),
    error_message TEXT
);

DELIMITER //

CREATE PROCEDURE example_procedure()
BEGIN
    DECLARE EXIT HANDLER FOR SQLEXCEPTION
    BEGIN
        ROLLBACK;
        INSERT INTO procedure_logs (procedure_name, status, error_message)
        VALUES ('example_procedure', 'FAILED', CONCAT('Error: ', SQLERRM));
    END;

    START TRANSACTION;
    -- 这里是存储过程的业务逻辑
    INSERT INTO example_table (column1, column2) VALUES ('value1', 'value2');
    COMMIT;

    INSERT INTO procedure_logs (procedure_name, status)
    VALUES ('example_procedure', 'SUCCESS');
END //

DELIMITER ;

CALL example_procedure();
SELECT * FROM procedure_logs;

GRANT EXECUTE ON your_database.* TO 'your_user'@'localhost';
GRANT INSERT ON your_database.procedure_logs TO 'your_user'@'localhost';

SHOW ERRORS;

CREATE TABLE IF NOT EXISTS procedure_logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    procedure_name VARCHAR(255) NOT NULL,
    execution_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    status VARCHAR(50),
    error_message TEXT
);