mysql怎样捕获异常

DELIMITER //

CREATE PROCEDURE handle_exception()
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
    BEGIN
        -- 异常处理代码
        ROLLBACK;
        SELECT 'An error has occurred, operation rolled back';
    END;

    START TRANSACTION;
    -- 这里放置可能引发异常的SQL代码
    INSERT INTO non_existent_table (column) VALUES ('value');
    COMMIT;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE handle_exception()
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
    BEGIN
        -- 异常处理代码
        ROLLBACK;
        SELECT 'An error has occurred, operation rolled back';
    END;

    START TRANSACTION;
    -- 这里放置可能引发异常的SQL代码
    INSERT INTO non_existent_table (column) VALUES ('value');
    COMMIT;
END //

DELIMITER ;

DELIMITER //

CREATE FUNCTION check_table_exists(table_name VARCHAR(255)) RETURNS INT
BEGIN
    DECLARE result INT;
    SELECT COUNT(*) INTO result FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = table_name;
    RETURN result;
END //

DELIMITER ;

SET @result = check_table_exists('non_existent_table');
IF @result = 0 THEN
    -- 表不存在的处理逻辑
END IF;