功能说明
Delete 语句删除数据时,自增列的值不会回收,值会一直单调增加的
示例
create table t1(a int auto_increment primary key,b varchar(100), c int);
insert into t1(b,c) values('a1',1),('a2',2),('a3',3),('a4',4),('a5',5);
gbase> SELECT * FROM t1;
+----+------+------+
| a
| b
| c
|
+----+------+------+
|
2 | a1
|
1 |
|
6 | a2
|
2 |
| 10 | a3
|
3 |
| 14 | a4
|
4 |
| 18 | a5
|
5 |
+----+------+------+
5 rows in set (Elapsed: 00:00:00.02)
gbase> delete from t1 where a = 3;
Query OK, 1 row affected (Elapsed: 00:00:00.06)
gbase> SELECT * FROM t1;
+----+------+------+
| a
| b
| c
|
+----+------+------+
|
2 | a1
|
1 |
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-04-10)
南大通用数据技术股份有限公司
1033
| 10 | a3
|
3 |
| 14 | a4
|
4 |
| 18 | a5
|
5 |
+----+------+------+
4 rows in set (Elapsed: 00:00:00.02)
gbase> insert into t1(b,c) values('a13',13);
Query OK, 1 row affected (Elapsed: 00:00:00.07)
gbase> SELECT * FROM t1;
+----+------+------+
| a
| b
| c
|
+----+------+------+
|
2 | a1
|
1 |
| 10 | a3
|
3 |
| 14 | a4
|
4 |
| 18 | a5
|
5 |
| 20 | a13
|
13 |
+----+------+------+
5 rows in set (Elapsed: 00:00:00.02)