blocks|key|475917|text|在SQL中使用LAST_INSERT_ID()|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|475918|++++SELECT+LAST_INSERT_ID();|code-block|syntax|javascript|475919|在PHP中使用mysql_insert_id()|475920|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id|1|http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html^0|7|G|0|0|0|7|H|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|K|3|-4|5|6|7|13|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]]]

Use <a href="http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id" rel="nofollow">LAST_INSERT_ID()</a> in SQL

<pre><code> SELECT LAST_INSERT_ID();
</code></pre>

Use <a href="http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html" rel="nofollow">mysql_insert_id()</a> in PHP

blocks|key|692251|text|如果您使用PHP来获取在INSERT语句之后返回的auto_incremented值，请尝试使用MySQLi+insert_id+function。较早的mysql_insert_id()版本在PHP中将被弃用。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|692252|下面是一个示例：|692253|+<?php
$mysqli+=+new+mysqli("localhost",+"my_user",+"my_password",+"world");

/*+check+connection+*/
if+(mysqli_connect_errno())+{
++++printf("Connect+failed:+%25s\n",+mysqli_connect_error());
++++exit();
}

$mysqli->query("CREATE+TABLE+myCity+LIKE+City");

$query+=+"INSERT+INTO+myCity+VALUES+(NULL,+'Stuttgart',+'DEU',+'Stuttgart',+617000)";
$mysqli->query($query);

printf+("New+Record+has+id+%25d.\n",+$mysqli->insert_id);

/*+drop+table+*/
$mysqli->query("DROP+TABLE+myCity");

/*+close+connection+*/
$mysqli->close();
?>|code-block|syntax|javascript|692254|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/mysqli.insert-id.php^0|1J|9|25|H|1C|P|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|6|7|12|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|13|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

If you are using PHP to get the auto_incremented value that is returned after an INSERT statement, try using the <a href="http://php.net/manual/en/mysqli.insert-id.php" rel="nofollow">MySQLi <code>insert_id</code> function</a>. The older <code>mysql_insert_id()</code> version is being deprecated in PHP.

An example below:

<pre><code> &lt;?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
 printf("Connect failed: %s\n", mysqli_connect_error());
 exit();
}

$mysqli-&gt;query("CREATE TABLE myCity LIKE City");

$query = "INSERT INTO myCity VALUES (NULL, 'Stuttgart', 'DEU', 'Stuttgart', 617000)";
$mysqli-&gt;query($query);

printf ("New Record has id %d.\n", $mysqli-&gt;insert_id);

/* drop table */
$mysqli-&gt;query("DROP TABLE myCity");

/* close connection */
$mysqli-&gt;close();
?&gt;
</code></pre>

blocks|key|692142|text|http://php.net/manual/en/function.mysql-insert-id.php|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|692143|entityMap|0|LINK|mutability|MUTABLE|url^0|0|1H|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@$A|L|B|M|1|N]]|C|$]]|$1|D|3|-4|5|6|7|O|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|4]]]]

<a href="http://php.net/manual/en/function.mysql-insert-id.php" rel="nofollow">http://php.net/manual/en/function.mysql-insert-id.php</a>

blocks|key|476072|text|如果您使用mysql_query("...")，那么mysql_insert_id()就是您需要的函数。如果您使用其他工具进行查询，则应检查相应的文档|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|476073|entityMap|0|LINK|mutability|MUTABLE|url|http://www.php.net/manual/en/function.mysql-insert-id.php^0|Q|H|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

If you use mysql_query("..."), then <a href="http://www.php.net/manual/en/function.mysql-insert-id.php" rel="nofollow">mysql_insert_id()</a> is the function you need. If you use something else to do queries, then the corresponding documentation should be checked

blocks|key|692330|text|在使用mysql_insert_id()时要小心，特别是当您有多个到数据库的连接时。因为它没有获得您插入的查询的值。它获取表的最新id。它可能是另一个查询插入的行。仅当您在一个连接中访问数据库时才使用此函数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|692331|https://www.php.net/manual/en/function.mysql-insert-id.php|offset|length|692332|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1M|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

Be Careful when using mysql_insert_id() specially if you have multiple connections to the Database. Because It doesn't get the value of the query you've inserted. it gets the latest id of the table. It may be a row another query has inserted. Only use this function if you access Database in one connection.

<a href="https://www.php.net/manual/en/function.mysql-insert-id.php" rel="nofollow noreferrer">https://www.php.net/manual/en/function.mysql-insert-id.php</a>

blocks|key|692023|text|mysqli_insert_id();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|692024|您还可以简单地运行以下查询：|unstyled|692025|INSERT+INTO+table+(foo)+VALUES+('bar')|692026|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|L|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|I|3|-4|5|F|7|N|8|@]|9|@]|A|$]]]|J|$]]

<pre><code>mysqli_insert_id();
</code></pre>

You can also simply run this query:

<pre><code>INSERT INTO table (foo) VALUES ('bar')
</code></pre>

blocks|key|692128|text|因为它是PHP，所以mysql_insert_id应该可以解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|692129|entityMap|0|LINK|mutability|MUTABLE|url|http://ch2.php.net/mysql_insert_id^0|A|F|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Since it's PHP, <a href="http://ch2.php.net/mysql_insert_id" rel="nofollow">mysql_insert_id</a> should do the trick

blocks|key|692172|text|看一下http://php.net/manual/en/function.mysql-insert-id.php中相当不错的示例|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|692173|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.mysql-insert-id.php^0|3|1H|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Take a look at the rather good example at <a href="http://php.net/manual/en/function.mysql-insert-id.php" rel="nofollow">http://php.net/manual/en/function.mysql-insert-id.php</a>

blocks|key|692278|text|在PDO中执行命令后也是如此，如下面的示例所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|692279|$lastId+=+$dbh->lastInsertId();|code-block|syntax|javascript|692280|单击查看REF|offset|length|692281|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/pdo.lastinsertid.php^0|0|0|4|3|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

also in PDO after the execute command as the example below:

<pre><code>$lastId = $dbh-&gt;lastInsertId();
</code></pre>

click for <a href="http://php.net/manual/en/pdo.lastinsertid.php" rel="nofollow">REF</a>

In my mysql table i have an id-column which is set to autoincrement.

then i do queries like this:

INSERT INTO table (id, foo) VALUES ('', 'bar')

how can i then safely find out which id was generated with this insert?

if i just query the last id this might not be safe, since another insert could have happened in the meantime, right?

PHP/MySQL Get autoincremented value after insert

数据库

在我的mysql表中，我有一个id-column，它被设置为自动增量。然后我像这样做查询：插入表格(id，foo)值(''，'bar')那么我如何安全地找出哪个id是通过这个插入生成的呢？如果我只查询最后一个id，这可能是不安全的，因为在此期间可能发生了另一次插入，对吧？

问PHP/MySQL在插入后获取自动递增的值
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHP/MySQL在插入后获取自动递增的值EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PHP/MySQL在插入后获取自动递增的值
EN