SHOW SEQUENCES

语法说明

SHOW SEQUENCES 用于查看当前序列列表的名称与列表类型。

语法结构

1. > SHOW SQUENCES
2. [WHERE expr]

示例

1. CREATE SEQUENCE s1 START 101;
2. CREATE SEQUENCE s3 as smallint INCREMENT 10 MINVALUE -100 MAXVALUE 100 START 0 CYCLE;
3. CREATE SEQUENCE seq_id INCREMENT BY 1 MAXVALUE 1000 START with 1;
4. mysql> show sequences;
5. +--------+-----------+
6. | Names  | Data Type |
7. +--------+-----------+
8. | s3     | SMALLINT  |
9. | s1     | BIGINT    |
10. | seq_id | BIGINT    |
11. +--------+-----------+
12. 3 rows in set (0.01 sec)