我将Node.js和TypeORM与MySQL一起使用,但是错误显示了MariaDB,我不知道为什么。我试图在用户实体中使用数组,这一定是错误
误差
QueryFailedError: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1
at processTicksAndReject
我正在使用NodeJs mysql模块,我想在实际查询密码之前检查账号是否存在。 下面是sql语句: let sql = `IF EXISTS (SELECT name FROM users WHERE name='${data.name}') SELECT password FROM users WHERE name='${data.name}'`; 如果没有if语句,一旦添加了IF EXISTS部件,无论我如何调整,总是会得到如下的错误: code: 'ER_PARSE_ERROR',
errno: 1064,
sqlMessage:
我为MariaDB10.1做了sql查询
但是,我将MariaDB10.1升级到10.3,但是出现了ER_PARSE_ERROR和SQL语法错误。
此错误是:
code: 'ER_PARSE_ERROR',
errno: 1064,
sqlMessage:
'You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to
use near \')\' a
我正在制作一个API,虽然触发的所有语法和查询都是正确的,但它向我展示了 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 'load' at line 1",
sqlState: '42000',
这是我的密码:
app.get('/user/:id', function (req, res) {
let Id = req.params.id;
console.log(Id);
connection.query('Select * from user where Id = ?', [Id], function (err, rows) {
if (err) return console.log(err);
if (rows.length) {
console.log('
我试图在服务器上分页,但我从MySQL得到一个语法错误。 抱歉,我是新来的,所以我不太明白陷阱在哪。 这是我的代码:(FullUrl它是这个表中的BASE_URL和url - column的组合) router.get('/', function (req, res) {
let numRows;
let numPerPage = parseInt(req.query.npp, 10) || 40;
let page = parseInt(req.query.page, 10) || 0;
let numPages;
let skip = page * n
我有一个sql insert,并且收到以下错误:
code: 'ER_PARSE_ERROR',
errno: 1064,
sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''CR0001'' at line 1",
sqlState: '42000',
这个sql查询是由squelize中的bulkCreate创建的。但是,它有什么问题呢?为什么它会出现呢?
code: 'ER_PARSE_ERROR',
errno: 1064,
sqlState: '42000',
sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''
我试图根据用户选择的表将数据从表发送到客户端。
/** GET ALL VAULES IN A PARTICULAR TABLE */
serve.get('/data/:id', (req, res)=>{
dbConn.query(
'SELECT * FROM ?',
[req.params.id],
(error, rows)=>{
if(!error){
//when there is no error
res.send(rows);
}else{
我正在尝试分别插入phone number和name,
然后我试着检索插入的记录,这是我的代码.
电话号码包含国家代码: Ex:+911234567890
app.get('/insertAndGetUser',(req,res) => {
console.log('insertAndGetUser method Called => ');
let name = req.query.username;
let phone = `+${req.query.number}`;
con.query(`insert into
我试图将对象数组插入到SQL中,但得到了以下错误
code: 'ER_PARSE_ERROR',
errno: 1064,
sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?,?)' at line 1",
sqlState: '42000',
index: 0,
我目前正在尝试执行这个sql查询,但我并不是最擅长的:
var sqlQuery = `
SELECT user.ID, user.email, user.first_name, user.last_name,
user.address1, user.address2, user.country, user.gender
FROM subscriber AS user
LEFT JOIN (
SELECT sID, name, experience, locked
FROM chars
) AS char
我想看看这是否可能,我的计划是使用客户端AJAX请求到每个字符输入的端点,根据从我的客户数据库检索的数据提供自动完整的建议。
我被困住了,因为我找不到合适的答案通过谷歌。我现在的SQL语句是
customerSearchAutoComplete = function(query, callback) {
connection.query('SELECT * FROM customer WHERE name LIKE % ? % OR address LIKE % ?', [query,query], function(err, rows, fields)
我正在尝试使用mysql包在discordjs中执行sql查询。查询(如果在sql server中使用)可以很好地工作,但我得到一个PARSE ERROR,试图在js中使用相同的查询: SET @ROW_NUMBER = 0; SELECT s.level,s.exp,s.number
FROM ( SELECT userID,level,exp,(@ROW_NUMBER:=@ROW_NUMBER + 1 ) AS number FROM levels ORDER BY level DESC) AS s
WHERE userID = "${userID}"; discor
假设有以下情况:
let sql: any = 'SELECT * FROM test_people ORDER BY :column :direction LIMIT :limit, :offset';
let binds: any = { column: 'name', direction: 'desc', limit: '1', offset: '10' };
let result = await mysql.query(sql, binds);
不管出于什么原因引发mysql语法错误,如果我替换绑定并将其
我有一个Node.JS服务器(目前是本地主机,但很快就会通过AWS),并且当我收到以下错误时,我正在尝试通过MySQL查询更新一个RDS实例:
{ [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 ''history0' = 'http://localhost:3000/' WHERE id
我对如何在node js中使用put语句有点困惑,目前我正在使用:
app.put("/cars/:id", (req, res) => { //get record based on id (uuid) e.g. http://localhost:3000/cars/a5ad957c-7d1b-11eb-8a21-0653a157c10e
connection.connect(function(err) {
connection.query(`UPDATE main.cars SET manufacturer= '${r
我试图将create过程查询从节点js发送到MYSQL。我正在读取Mysql.proc表以获得存储过程定义。
Mysql代码在从mysql客户机(如工作台或hedis )提交时运行良好。
在从NodeJS提交代码时获取以下错误
{ 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 'CREATE PROCEDURE `qwe`
我试图在一个名为身份验证的表中插入一个新的行,但是尽管我做了所有的修补工作,我仍然得到这个模糊的错误,在google搜索中没有得到任何具体的东西。错误: 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 '`token`
好的,所以我是新来的,所以我很抱歉,如果没有发现“明显的”问题。我试着用邮递员发布数据,但是我一直收到这个错误。有人知道问题出在哪里吗?
{
"error": {
"code": "ER_PARSE_ERROR",
"errno": 1064,
"sqlMessage": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL ser
我正在尝试通过mysql npm包更新mysql数据库。我正在使用表达式。我需要以下查询的帮助。 app.put("/api/movies/:id", (req, res) => {
let id = parseInt(req.params.id);
let values = [...Object.values(req.body)];
values.push(id);
let fields = 'SET Rank = ?, SET Title = ?, SET Description = ?, SET Runtime = ?,\
SET Ge