MYSQL语法错误，但所有内容都写对了

Question

我正在尝试使用node JS读取我的MySql数据库。我实际上已经在另一个文件中做了，在那里它工作得很好！我正在使用：

console.log('GuildId: ' + guildId);

let MemberCountChannel = new Map();{

connection.promise().query( guildId,
    `SELECT memberCountId FROM GuildConfigurable WHERE guildId = '${guildId}'`
).then(result => {
    MemberCountChannel.set(guildId, result[0][0].memberCountId);
    MemberCountChannelId = MemberCountChannel.get(guildId);

console.log(MemberCountChannelId);

我知道GuildId是对的，因为它把它记录在我代码的开头。在执行该代码时,我会得到以下信息：

GuildId: 776182101337833474
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 '776182101337833474' at line 1
    at PromiseConnection.query (/home/ubuntu/discord-bot-v2/node_modules/mysql2/promise.js:92:22)
    at Timeout._onTimeout (/home/ubuntu/discord-bot-v2/counters/member-counter.js:20:26)
    at listOnTimeout (node:internal/timers:556:17)
    at processTimers (node:internal/timers:499:7) {
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  sqlState: '42000',
  sqlMessage: "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 '776182101337833474' at line 1"
}

我已经尝试将“${guildId}”更改为仅为公会ID：

console.log('GuildId: ' + guildId);

    let MemberCountChannel = new Map();{

    connection.promise().query( guildId,
        `SELECT memberCountId FROM GuildConfigurable WHERE guildId = '776182101337833474'`
    ).then(result => {
        MemberCountChannel.set(guildId, result[0][0].memberCountId);
        MemberCountChannelId = MemberCountChannel.get(guildId);

    console.log(MemberCountChannelId);

但我得到了同样的输出。我的数据库表如下所示：

mysql> SELECT * FROM GuildConfigurable;
+--------------------+-----------+----------------+---------------+----------------+
| guildId            | cmdPrefix | radioChannelId | memberCountId | AutoStartRadio |
+--------------------+-----------+----------------+---------------+----------------+
| 776182101337833474 | <         | N/A            | N/A           | N              |
| 791351561182904381 | <         | N/A            | N/A           | N              |
| 804867729404067904 | <         | N/A            | N/A           | N              |
+--------------------+-----------+----------------+---------------+----------------+
3 rows in set (0.00 sec)

键入时：

SELECT memberCountId FROM GuildConfigurable WHERE guildId = 776182101337833474;
or
SELECT memberCountId FROM GuildConfigurable WHERE guildId = '776182101337833474';

在mysql控制台中,我得到了所需的输出：

SELECT memberCountId FROM GuildConfigurable WHERE guildId = 776182101337833474;
+---------------+
| memberCountId |
+---------------+
| N/A           |
+---------------+
1 row in set (0.01 sec)

你知道为什么我会犯这个错误吗？因为我很确定没有语法错误...

EDIT:

我已经完全重新安装了mysql2和mysql-server，并且在另一个文件中使用了基本相同的脚本来获取cmdprefix：

var guildId = message.guild.id; 
    getMemberCount(client, guildId);

    let guildCommandPrefix = new Map();
    connection.promise().query(
        `SELECT cmdPrefix FROM GuildConfigurable WHERE guildId = '${message.guild.id}'`
    ).then(result => {
        guildCommandPrefix.set(message.guild.id, result[0][0].cmdPrefix);
        prefix = guildCommandPrefix.get(message.guild.id);

这个很好用...

Answer 1

尝试在SELECT语句的末尾添加分号：

connection.promise().query( guildId,
        `SELECT memberCountId FROM GuildConfigurable WHERE guildId = '776182101337833474';`
    ).then(result => {
        MemberCountChannel.set(guildId, result[0][0].memberCountId);
        MemberCountChannelId = MemberCountChannel.get(guildId);