<p>我有这个POST请求</p> <pre class="brush:php;toolbar:false;">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 }); }); });</pre> <p>但是我从中得到了这个错误</p> <pre class="brush:php;toolbar:false;">"error": { "code": "ER_WRONG_VALUE_COUNT_ON_ROW", "errno": 1136, "sqlState": "21S01", "sqlMessage": "列计数与行 1 的值计数不匹配" }</pre> <p>这是表格</p> <pre class="brush:php;toolbar:false;">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 );</pre> <p>请问请求有什么问题？</p>

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 });

     });
 });