mysqli_insert_id是否有可能在高流量应用程序中返回错误的ID? [英] Is it possible for mysqli_insert_id to return an incorrect id in high traffic applications?

问题描述

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

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.

这篇关于mysqli_insert_id是否有可能在高流量应用程序中返回错误的ID?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！