mysql - 获取最后插入元素的ID

Question

基本上我有两张 table

User -> id, name , email , fname, lname etc...

Device -> id, name, user_id, etc......

首先，我将数据插入到用户表中，然后得到结果，从该结果中如何获取用户表条目的 ID，以便我可以将其用作设备中条目的 user_id基本上 user_id 是引用 User 表的 外键

我的插入代码是这样的

exports.user = function(req,res){
var user_email = req.param('email', null);
var user_fname = req.param('fname', null);
var user_lname = req.param('lname', null);
var user_phone = req.param('phone', null);
var user_description = req.param('description',null);

var user_data = {
    table:TABLE_USER,
    data:{
        'email':user_email,
        'fname':user_fname,
        'lname':user_lname,
        'phone':user_phone,
        'description':user_description
    }
}

db.insert(user_data,function (result) {
      //How to get the ID of the last inserted row from result, 
      // get Id and insert in device table
      res.writeHeader(200, {"Content-Type": "text/plain"});
      res.write(result[0] + " ");
      res.end();    
    }
    );
}

Answer 1

看看文档:Getting the id of an inserted row

他们的代码示例:

connection.query('INSERT INTO posts SET ?', {title: 'test'}, function(err, result) {
  if (err) throw err;

  console.log(result.insertId);
});