功能描述 在insert 后,调用此函数可以获取刚插入的自增列值,一次插入多行时,此函数 只返回插入第一行产生的值。 GBase 8a MPP Cluster 产品手册 5 数据库管理指南 文档版本953(2022-04-10) 南大通用数据技术股份有限公司 1039 示例 gbase> CREATE TABLE t1(a INT AUTO_INCREMENT PRIMARY KEY,b VARCHAR(100)); Query OK, 0 rows affected (Elapsed: 00:00:00.11) gbase> insert into t1(b) values('b1'); Query OK, 1 row affected (Elapsed: 00:00:00.09) gbase> insert into t1(b) values('b2'); Query OK, 1 row affected (Elapsed: 00:00:00.09) gbase> select * from t1; +---+------+ | a | b | +---+------+ | 2 | b1 | | 4 | b2 | +---+------+ 2 rows in set (Elapsed: 00:00:00.02) gbase> SELECT last_insert_id() from t1; +------------------+ | last_insert_id() | +------------------+ | 4 | | 4 | +------------------+ GBase 8a MPP Cluster 产品手册 5 数据库管理指南 文档版本953(2022-04-10) 南大通用数据技术股份有限公司 1040 2 rows in set (Elapsed: 00:00:00.02) gbase> insert into t1(b) values('b3'),('b4'); Query OK, 2 rows affected (Elapsed: 00:00:00.05) Records: 2 Duplicates: 0 Warnings: 0 gbase> select * from t1; +----+------+ | a | b | +----+------+ | 2 | b1 | | 4 | b2 | | 6 | b3 | | 10 | b4 | +----+------+ 4 rows in set (Elapsed: 00:00:00.04) gbase> SELECT last_insert_id() from t1; +------------------+ | last_insert_id() | +------------------+ | 6 | | 6 | | 6 | | 6 | +------------------+ 4 rows in set (Elapsed: 00:00:00.02) GBase 8a MPP Cluster 产品手册 5 数据库管理指南 文档版本953(2022-04-10) 南大通用数据技术股份有限公司 1041 gbase> create table t2(a int auto_increment primary key,b varchar(100)); Query OK, 0 rows affected (Elapsed: 00:00:00.13) gbase> insert into t2(b) values('a9'); Query OK, 1 row affected (Elapsed: 00:00:00.09) gbase> SELECT last_insert_id() from t2; +------------------+ | last_insert_id() | +------------------+ | 2 | +------------------+ 1 row in set (Elapsed: 00:00:00.03)