Can not write data into mySql from node.js

Question

Before I have made a test run and Everything was ok, but know when I am trying to insert a new static data it is saying that result is undefined. How to solve this?

const mysql = require("mysql")
const con = mysql.createConnection({
    host:"localhost",
    user:"root",
    password:"",
    database:"magebitdb"
});

con.connect((err)=>{
    if(err) throw err;
    console.log("connected to DB");
    

    // const sql =`INSERT INTO subscribers(email) VALUES (${email})`;
    const sqlInsert = ("INSERT INTO subscribers(email) VALUES ?")
    const values=[
        "test value"
    ]
    con.query(sqlInsert,[values],(err,result)=>{
        console.log(`inserted data is: ${result}`);
        console.log(values);
    });
});

`values` is already an array, you don't need to put it in another array with `[values]` — Barmar, Jan 13 '22 at 16:40
Not sure if inserting `[[values]]` is normal? Shouldn't it be `[values]` ? — Jeremy Thille, Jan 13 '22 at 16:40
There's probably an error, you should check if `err` is set and print that. — Barmar, Jan 13 '22 at 16:44
Actually, you need another level of array nesting. See https://stackoverflow.com/questions/8899802/how-do-i-do-a-bulk-insert-in-mysql-using-node-js — Barmar, Jan 13 '22 at 16:46
@Barmar it is not about array, the way that I wrote in code is correct. It does not affect to the result. — Riad8242, Jan 13 '22 at 16:56
@Barmar this is the sql error statement: 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 ''test value'' at line 1", — Riad8242, Jan 13 '22 at 16:56
If it didn't affect the result you wouldn't be getting that error. Change it to `[[values]]` and it should work, or change `values` to a 2-dimensional array. — Barmar, Jan 13 '22 at 17:04

score 0 · Answer 1 · answered Jan 13 '22 at 21:00

I have found the solution for this error.

I have console logged err in con.query and I noticed that in error there was no brackets and it was causing an error in the SQL syntax.

Basically I added brackets to sqlInsert and it worked const sqlInsert = ("INSERT INTO subscribers(email) VALUES (?)")

Can not write data into mySql from node.js

1 Answers1