Results of 1 - 3 of about 3 for conflicting (0.001 sec.)
- INSERT Statement 11924
- 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
...84) ON CONFLICT DO NOTHING; DO UPDATE Clause (Upsert) The DO UPDATE clause causes the INSERT to turn into an UPDATE on the conflicting row(s) instead. The SET expressions that follow determine how these rows are updated. The expressions can use the special...virtual table EXCLUDED , which contains the conflicting values for the row. Optionally you can provide an additional WHERE clause that can exclude certain rows from the update. T...RT statement contains multiple to-be-inserted rows that share the same conflict target, DuckDB applies only one update per conflicting key, and the row that wins is not guaranteed to be the last one in insertion order. In the example above, j ends up as 52... - https://man.mtool.work/duckdb/2.0/sql/statements/insert.html
- Troubleshooting 8129
- Troubleshooting Running EXPLAIN Renders Newlines In Python, the output of the EXPLAIN statement contains hard line breaks ( \n ): In [1]: import duckdb ...: duckdb.sql("EXPLAIN SELECT 42 AS x") Out[1]: ┌───────────────┬─────────────────────
...m 'google.protobuf.internal' (unknown location) The solution is to fix the protobuf package. This may require uninstalling conflicting packages, e.g.: %pip uninstall tensorflow %pip install protobuf... - https://man.mtool.work/duckdb/2.0/clients/python/known_issues.html
- ALTER TABLE Statement 7813
- The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples CREATE TABLE integers (i INTEGER, j INTEGER); Add a new column with name k to the table integers , it will be filled with the default value NULL : AL
...th ALTER TABLE and the DROP CONSTRAINT clause are not yet supported in DuckDB. Limitations ALTER COLUMN fails if values of conflicting types have occurred in the table at any point, even if they have been deleted: CREATE TABLE tbl (col VARCHAR); INSERT INTO... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work