Search Result: maxvalue - DuckDB 2.0 全文検索

CREATE SEQUENCE Statement 9414: The CREATE SEQUENCE statement creates a new sequence number generator. Examples Generate an ascending sequence starting from 1: CREATE SEQUENCE serial; Generate sequence from a given start number: CREATE SEQUENCE serial START 101; Generate ... TH 1 INCREMENT BY 2; Generate a descending sequence starting from 99: CREATE SEQUENCE serial START WITH 99 INCREMENT BY -1 MAXVALUE 99; By default, cycles are not allowed and will result in error, e.g.: Sequence Error: nextval: reached maximum value of s ... equence "serial" (10) CREATE SEQUENCE serial START WITH 1 MAXVALUE 10; CYCLE allows cycling through the same sequence repeatedly: CREATE SEQUENCE serial START WITH 1 MAXVALUE 10 CYCLE; Crea ... n the sequence. Parameters Name Description CYCLE or NO CYCLE The CYCLE option allows the sequence to wrap around when the maxvalue or minvalue has been reached by an ascending or descending sequence respectively. If the limit is reached, the next number ...; https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work