Home  >  Article  >  Database  >  MySQL的LAST_INSERT_ID用法举例_MySQL

MySQL的LAST_INSERT_ID用法举例_MySQL

WBOY
WBOYOriginal
2016-06-01 13:39:221046browse

bitsCN.com MySQL的LAST_INSERT_ID用法举例 环境:MySQL Sever 5.1 + MySQL命令行工具首先看个例子(主键是自增长): [sql] 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列的值。
参考资料:

MySQL的LAST_INSERT_ID用法http:///database/201208/151747.html;mysql中的LAST_INSERT_ID()分析http:///database/201206/137028.htmlMysql函数:Last_insert_id()语法讲解http:///database/201210/160986.html bitsCN.com

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn