环境：MySQL Sever 5.1 MySQL命令行工具 首先看个例子(主键是自增长)： mysql insert into bankaccount(name,balance) values(‘123’, 1000);Query OK, 1 row affected (0.06 sec)mysql insert into bankstatement(action, txdate, amt, toaccno, fromaccno)
环境：MySQL Sever 5.1 + MySQL命令行工具
首先看个例子(主键是自增长)：
mysql> insert into bankaccount(name,balance) values('123', 1000);Query OK, 1 row affected (0.06 sec)mysql> insert into bankstatement(action, txdate, amt, toaccno, fromaccno) values('122', curdate(), 1000, 1, 2);Query OK, 1 row affected (0.00 sec)mysql> select last_insert_id();+------------------+| last_insert_id() |+------------------+| 7 |+------------------+1 row in set (0.00 sec)mysql> select * from bankaccount;+-------+------+---------+| accno | name | balance |+-------+------+---------+| 1 | 张三 | 200 || 2 | 李四 | 900 || 3 | 123 | 1000 || 4 | 123 | 1000 |+-------+------+---------+4 rows in set (0.00 sec)mysql> select * from bankstatement;+----+--------------+------------+------+---------+-----------+| id | action | txdate | amt | toaccno | fromaccno |+----+--------------+------------+------+---------+-----------+| 1 | 开户 | 2012-10-1<div style="color:transparent">本文来源gaodai.ma#com搞#代!码(网</div>4 | 100 | NULL | 1 || 2 | 开户 | 2012-10-14 | 1000 | NULL | 2 || 3 | 查找账户信息 | 2012-10-14 | 0 | NULL | 2 || 4 | 查找账户信息 | 2012-10-14 | 0 | NULL | 1 || 5 | 转账 | 2012-10-14 | 100 | 1 | 2 || 6 | 122 | 2012-10-14 | 1000 | 1 | 2 || 7 | 122 | 2012-10-14 | 1000 | 1 | 2 |+----+--------------+------------+------+---------+-----------+7 rows in set (0.00 sec)
总结：LAST_INSERT_ID()返回最后一个INSERT或UPDATE语句中AUTO_INCREMENT列的值。
参考资料：
http://zhaohe162.blog.163.com/blog/static/38216797201122411193745/
http://it.100xuexi.com/view/otdetail/20120619/73a6cc8f-36b8-4b70-8904-57c18d3ab385.html
http://blog.gaodaima.com/wh62592855/article/details/6722298
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：MySQL的LAST_INSERT_ID用法举例
转载请注明原文链接：MySQL的LAST_INSERT_ID用法举例
