mysql触发器捕获异常

-- 创建表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

-- 创建日志表
CREATE TABLE user_insert_logs (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    message VARCHAR(255),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- 创建存储过程
DELIMITER $$
CREATE PROCEDURE check_age_and_log(IN user_id INT, IN age INT)
BEGIN
    DECLARE message VARCHAR(255);
    IF age < 18 OR age > 100 THEN
        SET message = CONCAT('Invalid age: ', age, ' for user id: ', user_id);
        INSERT INTO user_insert_logs (user_id, message) VALUES (user_id, message);
    END IF;
END$$
DELIMITER ;

-- 创建触发器
DELIMITER $$
CREATE TRIGGER before_user_insert
BEFORE INSERT ON users
FOR EACH ROW
BEGIN
    CALL check_age_and_log(NEW.id, NEW.age);
END$$
DELIMITER ;