javascript - 在使用 SELECT 附近的 sql sintaxis 中出错，代码 : 'ER_PARSE_ERROR' , errno: 1064

Question

我在 sql 查询中遇到错误。我得到了错误:代码:'ER_PARSE_ERROR'，错误号:1064。

我尝试将它直接复制并粘贴到数据库中并且它工作得很好但是当我在我的 nodejs 服务器上运行它时使用 mysql 我得到了错误。查询是:

SELECT  ER.id_entidad as companyid, E.nombre as name, ER.posicion as position, E.url_imagen as url,ER.created
FROM
entidad_red ER, cajero C, red R, entidad E
WHERE E.id_red = R.id_red AND C.id_red = E.id_red AND E.id_entidad = ER.id_entidad AND C.Serial = 'id'

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 \'SELECT ER.id_entidad as companyid, E.nombre as name, ER.posicion as position, \' at line 1'.

感谢帮助

这是我执行查询的方式:

const dbConnection = mysql.createConnection(config);

app.get('/kioskcompanies', middleware.checkToken, function(req, res){
        var serial = req.query.kioskid;
        var sql = "SELECT  ER.id_entidad as companyid, E.nombre as name, ER.posicion as position, E.url_imagen as url,ER.created " +
        "FROM entidad_red ER, cajero C, red R, entidad E " +
        "WHERE " +
        "E.id_red = R.id_red " +
        "AND C.id_red = E.id_red " +
        "AND E.id_entidad = ER.id_entidad " +
        "AND C.Serial = '" + serial + "'";
        console.log(sql)
        dbConnection.query(sql, (err, result) => {
            if(err){
                console.log(err);
                res.status(200).json({
                    status:'error',
                    code:"1",
                    msg:'Error consultando la BD',
                })
            }
            else if(result.length === 0){
                res.status(200).json({
                    status:'error',
                    code:"3",
                    msg:'Entidad de recaudo no existe.',
                })
            }
            else{
                res.status(200).json({
                    status:'error',
                    code:'0',
                    companies:result,
                    msg:'Consulta correcta'
                })
            }
        })
    })

Answer 1

我发现了问题。显然在 de Select 和我有两个空格的行之间，而 mysql-node 不适用于它。 PhpMyAdmin 会执行查询，但 Node 不会。