SHOW SEQUENCES
语法说明
SHOW SEQUENCES
用于查看当前序列列表的名称与列表类型。
语法结构
> SHOW SQUENCES
[WHERE expr]
示例
CREATE SEQUENCE s1 START 101;
CREATE SEQUENCE s3 as smallint INCREMENT 10 MINVALUE -100 MAXVALUE 100 START 0 CYCLE;
CREATE SEQUENCE seq_id INCREMENT BY 1 MAXVALUE 1000 START with 1;
mysql> show sequences;
+--------+-----------+
| Names | Data Type |
+--------+-----------+
| s3 | SMALLINT |
| s1 | BIGINT |
| seq_id | BIGINT |
+--------+-----------+
3 rows in set (0.01 sec)