mysql 取最后一个数字_mysql – 获取最后一个插入ID显示错误的数字

last_insert_id()与特定表无关.在同一连接中,所有表共享相同.

以下是它的演示.

演示：

mysql> create table t1(c1 int primary key auto_increment);

Query OK, 0 rows affected (0.11 sec)

mysql> create table t2(c1 int primary key auto_increment);

Query OK, 0 rows affected (0.06 sec)

mysql> insert into t1 values(null);

Query OK, 1 row affected (0.01 sec)

mysql> insert into t2 values(4);

Query OK, 1 row affected (0.00 sec)

mysql> insert into t2 values(null);

Query OK, 1 row affected (0.02 sec)

mysql> select last_insert_id() from t1;

+------------------+

| last_insert_id() |

+------------------+

| 5 |

+------------------+

1 row in set (0.00 sec)