SEQUENCES

SEQUENCES 表提供了有关序列的信息。TiDB 中序列的功能是参照 MariaDB 中的类似功能来实现的。

USE information_schema; DESC sequences;
+-----------------+--------------+------+------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------+------+------+---------+-------+ | TABLE_CATALOG | varchar(512) | NO | | NULL | | | SEQUENCE_SCHEMA | varchar(64) | NO | | NULL | | | SEQUENCE_NAME | varchar(64) | NO | | NULL | | | CACHE | tinyint(4) | NO | | NULL | | | CACHE_VALUE | bigint(21) | YES | | NULL | | | CYCLE | tinyint(4) | NO | | NULL | | | INCREMENT | bigint(21) | NO | | NULL | | | MAX_VALUE | bigint(21) | YES | | NULL | | | MIN_VALUE | bigint(21) | YES | | NULL | | | START | bigint(21) | YES | | NULL | | | COMMENT | varchar(64) | YES | | NULL | | +-----------------+--------------+------+------+---------+-------+ 11 rows in set (0.00 sec)
CREATE SEQUENCE test.seq; SELECT nextval(test.seq); SELECT * FROM sequences\G
+-------------------+ | nextval(test.seq) | +-------------------+ | 1 | +-------------------+ 1 row in set (0.01 sec) *************************** 1. row *************************** TABLE_CATALOG: def SEQUENCE_SCHEMA: test SEQUENCE_NAME: seq CACHE: 1 CACHE_VALUE: 1000 CYCLE: 0 INCREMENT: 1 MAX_VALUE: 9223372036854775806 MIN_VALUE: 1 START: 1 COMMENT: 1 row in set (0.00 sec)