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 ?

Udit Kumawat · Accepted Answer · 2018-03-26 08:34:32Z

16

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, 2018 at 8:34

Udit Kumawat

6941 gold badge8 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Evan Erickson Over a year ago

Why did you put ?, ?, ? after values and then a comma and then put the req.body after that?

Udit Kumawat Over a year ago

Because we are trying to insert 3 values in table row.

Evan Erickson Over a year ago

Gotcha my bad. I see you made the comment above too. Thank you for the quick response.

Salim Shamim Over a year ago

Any suggestion on inserting multiple rows?

Collectives™ on Stack Overflow

mysql2 inserting values nodejs

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest