您好，我在我的 discord.js 機器人中制作資料庫記錄。但是我收到了這個錯誤：
/home/container/node_modules/mysql/lib/protocol/Parser.js:437
throw err; // Rethrow non-MySQL errors
^
Error: ER_BAD_FIELD_ERROR: Unknown column 'narozeni' in 'field list'
at Query.Sequence._packetToError (/home/container/node_modules/mysql/lib/protocol/sequences/Sequence.js:47:14)
at Query.ErrorPacket (/home/container/node_modules/mysql/lib/protocol/sequences/Query.js:79:18)
at Protocol._parsePacket (/home/container/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/home/container/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/home/container/node_modules/mysql/lib/protocol/Parser.js:43:10)
at Protocol.write (/home/container/node_modules/mysql/lib/protocol/Protocol.js:38:16)
at Socket.<anonymous> (/home/container/node_modules/mysql/lib/Connection.js:88:28)
at Socket.<anonymous> (/home/container/node_modules/mysql/lib/Connection.js:526:10)
at Socket.emit (node:events:527:28)
at addChunk (node:internal/streams/readable:324:12)
--------------------
at Protocol._enqueue (/home/container/node_modules/mysql/lib/protocol/Protocol.js:144:48)
at Connection.query (/home/container/node_modules/mysql/lib/Connection.js:198:25)
at Handshake.<anonymous> (/home/container/commands/postava.js:132:20)
at Handshake.<anonymous> (/home/container/node_modules/mysql/lib/Connection.js:526:10)
at Handshake._callback (/home/container/node_modules/mysql/lib/Connection.js:488:16)
at Handshake.Sequence.end (/home/container/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)
at Handshake.Sequence.OkPacket (/home/container/node_modules/mysql/lib/protocol/sequences/Sequence.js:92:8)
at Protocol._parsePacket (/home/container/node_modules/mysql/lib/protocol/Protocol.js:291:23)
at Parser._parsePacket (/home/container/node_modules/mysql/lib/protocol/Parser.js:433:10)
at Parser.write (/home/container/node_modules/mysql/lib/protocol/Parser.js:43:10) {
code: 'ER_BAD_FIELD_ERROR',
errno: 1054,
sqlMessage: "Unknown column 'narozeni' in 'field list'",
sqlState: '42S22',
index: 0,
sql: 'INSERT INTO charaktery (jmeno, prijmeni, datumnarozeni, vek, cisloprukazu, discord, roblox) VALUES (`jmeno`, `prijmeni`, `narozeni`, `vek`, `randomp`, `discord.id`, `roblox`)'
}
代碼：
con.connect(function(err) {
if (err) throw err;
console.log("Connected!");
var sql = "INSERT INTO charaktery (jmeno, prijmeni, datumnarozeni, vek, cisloprukazu, discord, roblox) VALUES (`jmeno`, `prijmeni`, `narozeni`, `vek`, `randomp`, `discord.id`, `roblox`)";
con.query(sql, function (err, result) {
if (err) throw err;
console.log("1 record inserted");
});
});
D b：
圖片在這里！
我想在資料庫中做記錄。我實際上試圖給出價值觀`。但是還是會出現同樣的錯誤
uj5u.com熱心網友回復：
嘗試在原始 sql 查詢中使用單引號或雙引號。例如：
var sql = "INSERT INTO charaktery (jmeno, prijmeni, datumnarozeni, vek, cisloprukazu, discord, roblox) VALUES ('jmeno', 'prijmeni', 'narozeni', 'vek', 'randomp', 'discord.id', 'roblox')";
在 SQL 中不以這種方式使用反引號
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/536652.html