title: mysql2 inserting values nodejs
body: <p>I have this post request </p>
  
  <pre><code>app.post("/msg", (req, res) =&gt; {
    console.log(req.body)
    connection.query('INSERT INTO plans (topic, notes, resources) VALUES 
    (?)', [req.body.topic, req.body.note, req.body.resource],(error, 
    results) =&gt; {
       if (error) return res.json({ error: error });
  
       });
   });
  </code></pre>
  
  <p>and i get this error from  it </p>
  
  <pre><code>"error": {
      "code": "ER_WRONG_VALUE_COUNT_ON_ROW",
      "errno": 1136,
      "sqlState": "21S01",
      "sqlMessage": "Column count doesn't match value count at row 1"
  }
  </code></pre>
  
  <p>this is the table</p>
  
  <pre><code>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
   );
  </code></pre>
  
  <p>please whats wrong with the request ?</p>