mysql2 inserting values nodejs

Question

I have this post request

app.post("/msg", (req, res) => {
  console.log(req.body)
  connection.query('INSERT INTO plans (topic, notes, resources) VALUES 
  (?)', [req.body.topic, req.body.note, req.body.resource],(error, 
  results) => {
     if (error) return res.json({ error: error });

     });
 });

and i get this error from it

"error": {
    "code": "ER_WRONG_VALUE_COUNT_ON_ROW",
    "errno": 1136,
    "sqlState": "21S01",
    "sqlMessage": "Column count doesn't match value count at row 1"
}

this is the table

CREATE TABLE plans(
  id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  topic VARCHAR(64) NOT NULL,
  notes VARCHAR(200) NOT NULL,
  resources VARCHAR(200) NOT NULL
 );

please whats wrong with the request ?

score 13 · Accepted Answer · answered Mar 26 '18 at 08:34

13

You have to provide the question mark according to number of column values you are providing.

app.post("/msg", (req, res) => {
  console.log(req.body)
  connection.query('INSERT INTO plans (topic, notes, resources) VALUES 
  (?,?,?)', [req.body.topic, req.body.note, req.body.resource],(error, 
  results) => {
     if (error) return res.json({ error: error });

     });
 });

this should work

answered Mar 26 '18 at 08:34

Udit Kumawat

654
1
8
21

Why did you put ?, ?, ? after values and then a comma and then put the req.body after that? – Evan Erickson Nov 30 '21 at 05:14
Because we are trying to insert 3 values in table row. – Udit Kumawat Nov 30 '21 at 05:40
Gotcha my bad. I see you made the comment above too. Thank you for the quick response. – Evan Erickson Nov 30 '21 at 06:12
Any suggestion on inserting multiple rows? – Salim Shamim Nov 08 '22 at 08:13

mysql2 inserting values nodejs

1 Answers1

Linked

Related