使用MySQL检索上次插入的ID [英] Retrieve last inserted id with Mysql

问题描述

美好的一天，

我愿意在Mysql中检索新插入的行的ID值.

I am willing to retrieve the id value of a freshly inserted row in Mysql.

我知道有mysqli_insert_id函数，但是:

I know there is mysqli_insert_id function, but:

1. 我无法指定表格
2. 如果同时进行查询，则可能有检索错误ID的风险.
3. 我正在使用node.js MySQL

由于有很多查询，我不想冒着查询最高id的风险，这可能会给我一个错误的答案...

I don't want to take the risk to query the highest id since there are a lot of queries, it could give me the wrong one...

(我的id列处于自动递增状态)

(My id column is on auto-increment)

推荐答案

https://github.com/mysqljs/mysql#getting-the-id-of-an-inserted-row 完美地描述了解决方案:

https://github.com/mysqljs/mysql#getting-the-id-of-an-inserted-row describes the solution perfectly well:

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

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

拼写和存储库已移至github，所以我更改为当前链接.

spelling and the repo moved in github, so I changed to the current link.

这篇关于使用MySQL检索上次插入的ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！