blocks|key|1602291|text|从您的代码中不清楚您使用的是哪个DB抽象库(如果有的话)。它可以具有其自己的用于获得最后插入的id的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1602292|此外，只有在使用标准的mysql库时，mysql_insert_id()才会起作用。例如，如果您使用mysqli，这可能会工作得更好：|1602293|$last_id+=+$this->con->insert_id;|code-block|syntax|javascript|1602294|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

It is not clear from your code which DB abstraction library you are using (if any.) It may have its own method for obtaining last inserted id.

Also, mysql_insert_id() will work only if you use standard mysql library. If you use mysqli, for example, this may work better:

<pre><code>$last_id = $this-&gt;con-&gt;insert_id;
</code></pre>

blocks|key|506174|text|使用mysql_insert_id()函数|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|506175|$id+=+mysql_insert_id();|code-block|syntax|javascript|506176|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.mysql-insert-id.php^0|2|H|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

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

<pre><code>$id = mysql_insert_id();
</code></pre>

blocks|key|1604061|text|你试过$id+=+mysql_insert_id($con);或$id+=+$con->insert_id();吗？|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1604062|http://www.php.net/manual/en/mysqli.insert-id.php|1604063|http://www.php.net/manual/en/function.mysql-insert-id.php|1604064|entityMap|0|LINK|mutability|MUTABLE|url|1^0|3|S|W|O|0|0|1D|0|0|0|1L|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]|$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@]|D|@$9|X|A|Y|1|Z]]|E|$]]|$1|H|3|I|5|6|7|10|8|@]|D|@$9|11|A|12|1|13]]|E|$]]|$1|J|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|K|$L|$5|M|N|O|E|$P|G]]|Q|$5|M|N|O|E|$P|I]]]]

Have you tried <code>$id = mysql_insert_id($con);</code> or <code>$id = $con-&gt;insert_id();</code> ?

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

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

blocks|key|506212|text|mysql_insert_id返回最后插入的记录more+info+here的id|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|506213|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.mysql-insert-id.php^0|O|E|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]]]]

mysql_insert_id returns the id of the last inserted record
<a href="http://php.net/manual/en/function.mysql-insert-id.php" rel="nofollow">more info here</a>

blocks|key|2573047|text|<?php
$link+=+mysql_connect('localhost',+'mysql_user',+'mysql_password');
if+(!$link)+{
++++die('Could+not+connect:+'+.+mysql_error());
}
mysql_select_db('mydb');

mysql_query("INSERT+INTO+mytable+(product)+values+('kossu')");
printf("Last+inserted+record+has+id+%25d\n",+mysql_insert_id());
?>|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2573048|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>&lt;?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
 die('Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');

mysql_query("INSERT INTO mytable (product) values ('kossu')");
printf("Last inserted record has id %d\n", mysql_insert_id());
?&gt;
</code></pre>

blocks|key|2573074|text|只需在插入后调用mysql_insert_id()。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2573075|entityMap^0|8|H|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Just call <code>mysql_insert_id()</code> after insertion.

blocks|key|4170343|text|你也可以这样做|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4170344|SELECT+last_insert_id();|code-block|syntax|javascript|4170345|在一个单独的查询中，如果您正在做的任何DB库都没有自己的方法(通常只是发出这个查询)。只要您使用相同的DB句柄，就可以保证获得执行的最后一次插入操作的ID。|4170346|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

You can also do

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

in a seperate query, if whatever DB library you're doing doesn't have its own method for this (which generally just issue this query anyways). As long as you're using the same DB handle, you're guaranteed to get the ID of the last insertion opereration performed.

blocks|key|4170254|text|很简单，通过id描述来进行常规的选择排序|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4170255|像这样的东西|4170256|"SELECT+*+FROM+tu_cla_facets+ORDER+BY+id+DESC+LIMIT+1"|offset|length|style|CODE|4170257|仅当您在脚本执行期间执行插入操作时，mysql_insert_id才会起作用|4170258|编辑:这将总是得到最后插入的行，在一些罕见的情况下，这可能不是你刚插入的行。|4170259|entityMap^0|0|0|0|1I|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@$F|S|G|T|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

well simple make a regular select order by id desc 

something like this

<code>"SELECT * FROM tu_cla_facets ORDER BY id DESC LIMIT 1"</code>

the mysql_insert_id will only work if you during the script made an insert

edit: this will always get the last inserted row which in some rare cases but possible doesn't has to be the very row you just insert.

<pre><code>$sql="INSERT INTO tu_cla_facets VALUES(null,\"".addslashes($facet)."\",\"".addslashes($description)."\",\"".$parentId."\",\"\",\"".addslashes($leafFacet)."\",\"".addslashes($hidden)."\",\"\",'',NOW(),\"".$username."\",NOW(),\"".$username."\",\"\",\"\");"; 
 $res=$this-&gt;con-&gt;query($sql);
</code></pre>

This is the code of inserting, how to get the ID of this row? It's an auto-increment.

How to get the ID of the last inserted row in the table in MySql with PHP

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

$sql="INSERT INTO tu_cla_facets VALUES(null,\"".addslashes($facet)."\",\"".addslashes($description)."\",\"".$parentId."\",\"\",\"".addslashes($leafFacet)."\",\"".addslashes($hidden)."\",\"\",'',NOW(),

问如何在MySql中获取表中最后插入行的ID
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySql中获取表中最后插入行的IDEN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在MySql中获取表中最后插入行的ID
EN