mysql 储存过程调试

DELIMITER //

CREATE PROCEDURE TestProc()
BEGIN
    -- 错误的SQL语句
    SELECT * FROM non_existent_table;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE TestProc(IN input_param INT)
BEGIN
    -- 错误的逻辑
    IF input_param > 10 THEN
        SELECT * FROM table WHERE column = 'value';
    ELSE
        SELECT * FROM table WHERE column = input_param;
    END IF;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE TestProc()
BEGIN
    -- 低效的查询
    SELECT * FROM large_table WHERE column = 'value';
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE DebugProc(IN input_param INT)
BEGIN
    DECLARE result VARCHAR(255);
    
    -- 添加日志记录
    SELECT CONCAT('Input parameter: ', input_param) INTO result;
    SELECT result;
    
    -- 正确的逻辑
    IF input_param > 10 THEN
        SELECT * FROM table WHERE column = 'value';
    ELSE
        SELECT * FROM table WHERE column = input_param;
    END IF;
END //

DELIMITER ;