我正在制作一个API,虽然触发的所有语法和查询都是正确的,但它向我展示了 code: 'ER_PARSE_ERROR', sqlMessage: "You havean error in your SQL syntax; check the manual that corresponds to your MySQL server version for the rightsyntax to
下面是sql语句: let sql = `IF EXISTS (SELECT name FROM users WHERE name='${data.name}') SELECT password FROMusers WHERE name='${data.name}'`; 如果没有if语句,一旦添加了IF EXISTS部件,无论我如何调整,总是会得到如下的错误: code: 'ER_PARSE_ERROR',
errno: 1064</e
我有一个sql insert,并且收到以下错误: errno: 1064,
sqlMessage: "You have an error inyour SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntaxto use near
这个sql查询是由squelize中的bulkCreate创建的。但是,它有什么问题呢?为什么它会出现呢?code: 'ER_PARSE_ERROR', sqlState: '42000',
sqlMessage: "You have an error inyour SQL syntax; check the manual that correspond