sql insert into query&post方法

Question

   app.post('/form',function (req,res) {
        var post = req.body

  dbconn.query('INSERT INTO employee SET?',[post],function(err,result){
                  if(err)

               console.log(err);
           else
               console.log('inserted ');

        });

Answer 1

插入查询语法不正确。

并且请确保post变量包含右数组

应该是

post = [
    [EmpID1, Name1, EmpCode1, Salary1],
    [EmpID2, Name2, EmpCode2, Salary2]

];

 dbconn.query('INSERT INTO employee (EmpID, Name, EmpCode, Salary) VALUES 
   ?',[post],function(err,result){
        if(err)
           console.log(err);
        else
           console.log('inserted ');

 });