SEQUENCES

    输出结果如下:

    1. +-----------------+--------------+------+------+---------+-------+
    2. | Field | Type | Null | Key | Default | Extra |
    3. +-----------------+--------------+------+------+---------+-------+
    4. | TABLE_CATALOG | varchar(512) | NO | | NULL | |
    5. | SEQUENCE_SCHEMA | varchar(64) | NO | | NULL | |
    6. | SEQUENCE_NAME | varchar(64) | NO | | NULL | |
    7. | CACHE | tinyint(0) | NO | | NULL | |
    8. | CACHE_VALUE | bigint(21) | YES | | NULL | |
    9. | CYCLE | tinyint(0) | NO | | NULL | |
    10. | INCREMENT | bigint(21) | NO | | NULL | |
    11. | MAX_VALUE | bigint(21) | YES | | NULL | |
    12. | START | bigint(21) | YES | | NULL | |
    13. | COMMENT | varchar(64) | YES | | NULL | |
    14. +-----------------+--------------+------+------+---------+-------+
    15. 11 rows in set (0.00 sec)

    输出结果如下:

    1. +-------------------+
    2. | nextval(test.seq) |
    3. +-------------------+
    4. | 1 |
    5. +-------------------+
    6. 1 row in set (0.01 sec)

    输出结果如下:

    1. SEQUENCE_SCHEMA: test
    2. SEQUENCE_NAME: seq
    3. CACHE: 1
    4. CACHE_VALUE: 1000
    5. CYCLE: 0
    6. INCREMENT: 1
    7. MAX_VALUE: 9223372036854775806
    8. MIN_VALUE: 1
    9. START: 1
    10. COMMENT: