You are viewing the archived documentation of TiDB, which no longer receives updates.

View latest LTS version docs

SEQUENCES

The SEQUENCES table provides information about sequences. The sequences feature is modeled on a similar feature in 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)