您的SQL語法有錯誤；檢查與您的MySQL服務器版本相對應的手冊，以獲取在“WHEREid='1''附近使用的正確語法

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 'WHERE id = '1'' at line 1
    at Query.Sequence._packetToError (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)  
    at Query.ErrorPacket (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\protocol\sequences\Query.js:79:18)
    at Protocol._parsePacket (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\protocol\Protocol.js:291:23)
    at Parser._parsePacket (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\protocol\Parser.js:433:10)
    at Parser.write (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\protocol\Parser.js:43:10)
    at Protocol.write (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\protocol\Protocol.js:38:16)
    at Socket.<anonymous> (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\Connection.js:88:28)
    at Socket.<anonymous> (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\Connection.js:526:10)
    at Socket.emit (node:events:390:28)
    at addChunk (node:internal/streams/readable:315:12)
    --------------------
    at Protocol._enqueue (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\protocol\Protocol.js:144:48)
    at Connection.query (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\mysql\lib\Connection.js:198:25)
    at exports.update (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\server\controllers\userController.js:81:14)
    at Layer.handle [as handle_request] (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\express\lib\router\layer.js:95:5)
    at next (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\express\lib\router\route.js:144:13)
    at Route.dispatch (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\express\lib\router\route.js:114:3)
    at Layer.handle [as handle_request] (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\express\lib\router\layer.js:95:5)
    at D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\express\lib\router\index.js:284:15
    at param (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\express\lib\router\index.js:365:14)
    at param (D:\Softwares\usermana\Nodejs-UserManagement-Express-Hbs-MySQL\node_modules\express\lib\router\index.js:376:14) {
  code: 'ER_PARSE_ERROR',
  errno: 1064,
  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 'WHERE id = '1'' at line 1",
  sqlState: '42000',
  index: 0,
 
}
The data from user table:
 undefined

我試圖從管理頁面動態更新我的登錄詳細資訊，但是當我單擊提交時它會引發錯誤

這是我的資料庫結構

[

uj5u.com熱心網友回復：

你在“where”之前有逗號，它不能在那里。只需將其洗掉。

uj5u.com熱心網友回復：

在您的代碼中有一個額外的單引號，請洗掉它。

問號之后?'

現在的代碼是什么？

哪里 id = ？,

代碼應該是什么？

在哪里 id = ？,

標籤：sql节点.js数据库npm

上一篇：SQL計算用戶出現在兩個不同表中的百分比

下一篇：在這個實體中如何避免Sql回圈參考？