MySQL的LAST_INSERT_ID用法举例 - 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-14 |  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://www.bianceng.cn/database/MySQL/

（编辑：佛山站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!