Results of 1 - 2 of about 2 for qualifier (0.001 sec.)
- INSERT Statement 11228
- The INSERT statement inserts new data into a table. Examples Insert the values 1, 2, 3 into tbl : INSERT INTO tbl VALUES (1), (2), (3); Insert the result of a query into a table: INSERT INTO tbl SELECT * FROM other_tbl; Insert values into t
...Because we need a way to refer to both the to-be-inserted tuple and the existing tuple, we introduce the special EXCLUDED qualifier. When the EXCLUDED qualifier is provided, the reference refers to the to-be-inserted tuple, otherwise, it refers to the ex...isting tuple. This special qualifier can be used within the WHERE clauses and SET expressions of the ON CONFLICT clause. CREATE TABLE tbl (i INTEGER PRIMARY KE... - https://man.mtool.work/duckdb/2.0/sql/statements/insert.html
- NULL Values 7485
- NULL values are special values that are used to represent missing data in SQL. Columns of any type can contain NULL values. Logically, a NULL value can be seen as “the value of this field is unknown”. A NULL value can be inserted to any fie
...ld that does not have the NOT NULL qualifier: CREATE TABLE integers (i INTEGER); INSERT INTO integers VALUES (NULL); NULL values have special semantics in many parts o... - https://man.mtool.work/duckdb/2.0/sql/data_types/nulls.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work