一个查询中的node-mysql多条语句?mysql

我正在使用nodejs 10.26+ express 3.5+ node-mysql 2.1.1+ MySQL-Server Version: 5.6.16。

我有4个DELETE，并且只需要1个数据库请求，因此我将DELETE命令与“;” ...相连，但是它总是失败。

var sql_string = "DELETE FROM user_tables WHERE name = 'Testbase';"; sql_string += "DELETE FROM user_tables_structure WHERE parent_table_name = 'Testbase';"; sql_string += "DELETE FROM user_tables_rules WHERE parent_table_name = 'Testbase';"; sql_string += "DELETE FROM user_tables_columns WHERE parent_table_name = 'Testbase';";

connection.query(sql_string, function(err, rows, fields) { if (err) throw err; res.send('true'); }); 它引发此错误：

Error: ER_PARSE_ERROR: 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 'DELETE FROM user_tables_structure WHERE parent_table_name = 'Testbase';DELETE FR' at line 1 但是，如果我将此SQL粘贴到PhpMyAdmin中，它将始终成功...

如果我在单个查询中写它也是成功的。

    connection.query("DELETE FROM user_tables WHERE name = 'Testbase'", function(err, rows, fields) {
    if (err) throw err;

    connection.query("DELETE FROM user_tables_structure WHERE parent_table_name = 'Testbase'", function(err, rows, fields) {
        if (err) throw err;


        connection.query("DELETE FROM user_tables_rules WHERE parent_table_name = 'Testbase'", function(err, rows, fields) {
            if (err) throw err;

            connection.query("DELETE FROM user_tables_columns WHERE parent_table_name = 'Testbase'", function(err, rows, fields) {
                if (err) throw err;

                res.send('true');
            });
        });
    });
});

感谢帮助！