mysqli_insert_id 是否有可能在高流量应用程序中返回错误的 id?

2021-12-25 00:00:00 php mysql mysqli high-traffic

在高流量应用程序中,mysqli_insert_id() 是否有可能返回错误的 id,或者在几乎同时执行的两个 INSERT 查询之间混淆 id?

In a high traffic application, is it possible for mysqli_insert_id() to return the wrong id, or to confuse the id between two INSERT queries performed nearly simultaneously?

推荐答案

没有.mysqli_insert_id 返回当前连接上最近 INSERT 查询中最多的 AUTO_INCREMENT 值.例如,它永远不会与其他连接混淆.

No. mysqli_insert_id returns the most the AUTO_INCREMENT value from the most recent INSERT query on the current connection. It will never get confused with another connection, for example.

相关文章