mysql - ER_PARSE_ERROR : You have an error in your SQL syntax;

Question

为什么不起作用？我想下载txt并保存在数据库中。

Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual th at corresponds to your MySQL server version for the right syntax to use near 'a/ innego komunikatora. Z góry, wielkie dzięki. Temat będzie aktualizowany w m' at line 1

代码

var cheerio = require('cheerio');
const request = require('request');
var mysql = require('mysql');


var con = mysql.createConnection({
  password..
});


con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");
});


let x=1;

function downlad(){
    x++;
    request.get(`http://wklejto.pl/638151`, (err, response, body) => {
        console.log(response.statusCode);
        const $=cheerio.load(
          body,
          { decodeEntities: false });

        const el = $('.de1').html();

        con.query("INSERT INTO `wklejki` (`ID`, `txt`) VALUES (NULL, '"+el+"');");

        console.log(el);
    });
}downlad();

Enter image description here

Answer 1

替换

con.query("INSERT INTO `wklejki` (`ID`, `txt`) VALUES (NULL, '"+el+"');");

与

con.query('INSERT INTO wklejki SET ?', {ID: null, txt: el}, function (error, results, fields) {
    //Whatever you want to do next.
});