|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
mysql> select * from table1; +----+------+-----------+ | id | name | addr | +----+------+-----------+ | 1 | Tom | Beijing | | 2 | Lee | 123 | | 3 | Lee | 123 | | 4 | wu | chongqing | +----+------+-----------+ 4 rows in set (0.00 sec) mysql> insert into table1(name, addr) values("feng", "chengdu"); Query OK, 1 row affected (0.00 sec) mysql> select last_insert_id; ERROR 1054 (42S22): Unknown column 'last_insert_id' in 'field list' mysql> select last_insert_id(); +------------------+ | last_insert_id() | +------------------+ | 5 | +------------------+ 1 row in set (0.00 sec) mysql> select last_insert_id() as lastid; +--------+ | lastid | +--------+ | 5 | +--------+ 1 row in set (0.00 sec) mysql> |
转载请注明：Imekaku-Blog » MySQL select上次插入的数据id
