Results of 1 - 3 of about 3 for serial (0.001 sec.)
- CREATE SEQUENCE Statement 11924
- 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
...odd numbers using INCREMENT BY : CREATE SEQUENCE serial START WITH 1 INCREMENT BY 2; Generate a descending sequence starting from 99: CREATE SEQUENCE serial START WITH 99 INCREME...efault, cycles are not allowed and will result in error, e.g.: Sequence Error: nextval: reached maximum value of sequence "serial" (10) CREATE SEQUENCE serial START WITH 1 MAXVALUE 10; CYCLE allows cycling through the same sequence repeatedly: CREATE S...EQUENCE serial START WITH 1 MAXVALUE 10 CYCLE; Creating and Dropping Sequences Sequences can be created and dropped similarly to other ca... - https://man.mtool.work/duckdb/2.0/sql/statements/create_sequence.html
- Excel Export 8036
- DuckDB supports exporting data to Excel .xlsx files via the excel extension. Please note that .xls files are not supported. To install and load the extension, run: INSTALL excel; LOAD excel; Exporting Excel Sheets To export a table to an Ex
...ng XLSX files: Numeric types are cast to DOUBLE . Temporal types ( TIMESTAMP , DATE , TIME , etc.) are converted to Excel "serial" numbers, that is the number of days since 1900-01-01 for dates and the fraction of a day for times. These are then styled... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_export.html
- Excel Extension 7906
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...are cast to DOUBLE when writing to an XLSX file. Temporal types ( TIMESTAMP , DATE , TIME , etc.) are converted to excel "serial" numbers, that is the number of days since 1900-01-01 for dates and the fraction of a day for times. These are then styled... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work