功能描述
在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)