多语句MySQL查询报语法错误，单语句执行正常求排查

数据老陈

2026-8-21

问题：MySQL批量执行命令时出现语法错误，单独执行正常

我尝试执行以下MySQL命令：

USE database_name;
DROP TEMPORARY TABLE IF EXISTS only_with_balance;
DROP TEMPORARY TABLE IF EXISTS keys_to_match;

CREATE TEMPORARY TABLE only_with_balance as (
    SELECT 
    *
FROM 
    transactions t 
WHERE 
    t.balance is not NULL
    and (t.transaction_status_id = 4 or t.transaction_status_id = 5)
    and (t.date between "2022-05-01" and "2022-08-24" )
);

但一次性执行所有命令时出现语法错误：

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TEMPORARY TABLE IF EXISTS only_with_balance;
DROP TEMPORARY TABLE IF EXIST' at line 2

单独执行每条命令时，结果符合预期。请问该如何解决？我遗漏了什么？

原因与解决方法

核心问题：你的SQL语句存在语法错误——CREATE TEMPORARY TABLE定义后多了一个额外的);，导致整个批量执行的语句结构混乱，MySQL无法正确解析后续命令。同时需确认客户端是否开启多语句执行支持。
具体修正步骤：
1. 移除CREATE语句末尾多余的);，确保CREATE TEMPORARY TABLE ... AS (SELECT ...)结构完整闭合。
2. 检查你的SQL客户端设置，确保开启多语句执行功能（比如MySQL Workbench需要在连接设置中启用「Allow Multiple Queries」，部分客户端默认关闭该选项）。
修正后的完整SQL：

USE database_name;
DROP TEMPORARY TABLE IF EXISTS only_with_balance;
DROP TEMPORARY TABLE IF EXISTS keys_to_match;

CREATE TEMPORARY TABLE only_with_balance AS (
    SELECT *
    FROM transactions t 
    WHERE 
        t.balance IS NOT NULL
        AND (t.transaction_status_id = 4 OR t.transaction_status_id = 5)
        AND (t.date BETWEEN '2022-05-01' AND '2022-08-24')
);