Results of 1 - 10 of about 46 for Delete (0.002 sec.)
- Editing 13013
- The linenoise-based CLI editor is available for macOS, Linux and Windows. DuckDB's CLI uses a line-editing library based on linenoise , which has shortcuts that are based on Emacs mode of readline . Below is a list of available commands. Yo
...+ Down Move to last history entry Alt + N Search the history Alt + P Search the history Changing Text Key Action Backspace Delete previous character Delete Delete next character Ctrl + D Delete next character. When buffer is empty, end editing Ctrl + H...Delete previous character Ctrl + K Delete everything after the cursor Ctrl + T Swap character under cursor with previous characte...r Ctrl + U Delete all text Ctrl + W Delete previous word Alt + C Convert next word to titlecase Alt + D Delete next word Alt + L Convert nex... - https://man.mtool.work/duckdb/2.0/clients/cli/editing.html
- DELETE Statement 11853
- The DELETE statement removes rows from the table identified by the table-name. If the WHERE clause is not present, all records in the table are deleted. If a WHERE clause is supplied, then only those rows for which the WHERE clause results
...in true are deleted. Rows for which the expression is false or NULL are retained. Examples Remove the rows matching the condition i = 2 from...the database: DELETE FROM tbl WHERE i = 2; Delete all rows in the table tbl : DELETE FROM tbl; USING Clause The USING clause allows deleting ba...sed on the content of other tables or subqueries. RETURNING Clause The RETURNING clause allows returning the deleted values. It uses the same syntax as the SELECT clause except the DISTINCT modifier is not supported. CREATE TABLE employee... - https://man.mtool.work/duckdb/2.0/sql/statements/delete.html
- Writing to Iceberg 11365
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...s the following operations when used with a REST Catalog attached: CREATE/DROP SCHEMA CREATE/DROP TABLE INSERT INTO UPDATE DELETE MERGE INTO ALTER TABLE SELECT Since these operations are supported, the following will also work: COPY FROM DATABASE duckd...es.events; Table properties can also be inspected and modified after creation, see Table Properties Functions . UPDATE and DELETE The UPDATE and DELETE statements are supported on both partitioned and unpartitioned tables: UPDATE iceberg_catalog.sales....events SET event_name = 'view' WHERE id = 1; DELETE FROM iceberg_catalog.sales.events WHERE event_time < TIMESTAMP '2026-01-01'; They use merge-on-read semantics and write po... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- MERGE INTO Statement 11304
- The MERGE INTO statement is an alternative to INSERT INTO ... ON CONFLICT that doesn't need a primary key since it allows for a custom match condition. This is a very useful alternative for upserting use cases ( INSERT + UPDATE ) when the d
...M people ORDER BY id; id name salary 1 John 98000.0 2 Anna 100000.0 3 Sarah 95000.0 Another common pattern is to receive a delete set of rows, which may only contain ids of rows to be deleted. MERGE INTO people USING ( SELECT 1 AS id, ) AS deletes USIN...G (id) WHEN MATCHED THEN DELETE; FROM people ORDER BY id; id name salary 2 Anna 100000.0 3 Sarah 95000.0 MERGE INTO also supports more complex conditions,...for example, for a given delete set we can decide to only remove rows that contain a salary bigger or equal than a certain amount. MERGE INTO people USING... - https://man.mtool.work/duckdb/2.0/sql/statements/merge_into.html
- Replacement Scans 9946
- The replacement scan API can be used to register a callback that is called when a table is read that does not exist in the catalog. For example, when a query such as SELECT * FROM my_table is executed and my_table does not exist, the replac
...duckdb_add_replacement_scan ( duckdb_database db , duckdb_replacement_callback_t replacement , void * extra_data , duckdb_delete_callback_t delete_callback ); void duckdb_replacement_scan_set_function_name ( duckdb_replacement_scan_info info , const c...duckdb_add_replacement_scan ( duckdb_database db , duckdb_replacement_callback_t replacement , void * extra_data , duckdb_delete_callback_t delete_callback ); Parameters db : The database object to add the replacement scan to replacement : The replace...ment scan callback extra_data : Extra data that is passed back into the specified callback delete_callback : The delete callback to call on the extra data, if any duckdb_replacement_scan_set_function_name Sets the replac... - https://man.mtool.work/duckdb/2.0/clients/c/replacement_scans.html
- Indexes 9580
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...UPDATE Statements UPDATE statements on indexed columns and columns that cannot be updated in place are transformed into a DELETE of the original row followed by an INSERT of the updated row. This rewrite has performance implications, particularly for...e number of rows exceeds DuckDB's standard vector size, which is 2048 by default. The UPDATE statement is rewritten into a DELETE , followed by an INSERT . This rewrite happens per chunk of data (2048 rows) moving through DuckDB's processing pipeline....+ 1; Constraint Error: Duplicate key "i: 2048" violates primary key constraint. A workaround is to split the UPDATE into a DELETE ... RETURNING ... followed by an INSERT , with some additional logic to (temporarily) store the result of the DELETE . All... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- CREATE TRIGGER Statement 8543
- New The CREATE TRIGGER feature was introduced in DuckDB 2.0. The CREATE TRIGGER statement registers a trigger: a set of SQL statements that run automatically in response to INSERT , UPDATE , or DELETE events on a table. Examples Record ever
...ax The triggered statement is a single SQL statement, typically a data modification statement such as INSERT , UPDATE , or DELETE . Timing BEFORE triggers run before the triggering statement is applied. AFTER triggers run after the triggering statement...ow affected by the statement. The triggered statement can refer to the affected row through NEW (for INSERT ) and OLD (for DELETE ). Row-level UPDATE triggers are not yet supported; see the limitations . FOR EACH STATEMENT fires the trigger once per st...ables: NEW TABLE contains the inserted or post-update rows and is available for INSERT and UPDATE . OLD TABLE contains the deleted or pre-update rows and is available for UPDATE and DELETE . OR REPLACE and IF NOT EXISTS CREATE OR REPLACE TRIGGER replac... - https://man.mtool.work/duckdb/2.0/sql/statements/create_trigger.html
- Merge Statement for SCD Type 2 8360
- This is a practical, step-by-step guide to using DuckDB's MERGE statement (introduced in v1.4.0) to perform upserts and build Slowly Changing Dimension Type 2 (SCD Type 2) tables . Type 2 SCDs let you keep full historical versions of record
...nd for how long it was in a particular state. Why Use MERGE in DuckDB? Single SQL statement for INSERT , UPDATE , and soft DELETE (upsert and expire). Much cleaner and faster than equivalent Python/Pandas logic. Full history tracking without hard delet...ery ON Join condition (usually primary/business key + current flag) WHEN MATCHED Row exists in both → typically UPDATE (or DELETE) WHEN NOT MATCHED BY TARGET New row (insert) WHEN NOT MATCHED BY SOURCE Row disappeared → soft-delete/expire old version R...ETURNING merge_action Optional: shows what happened to each row (INSERT/UPDATE/DELETE) Build an SCD Type 2 Dimension Table We'll track ducks and preserve history whenever their name, breed, or location change... - https://man.mtool.work/duckdb/2.0/guides/sql_features/merge.html
- Deploying Quack 7917
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...ROM quack_query_by_name('remote', 'SELECT current_setting(''threads'')'); Tearing Down When you're done with the instance, delete the stack: aws cloudformation delete-stack --stack-name quack-demo --region us-east-1 Or use the Delete button in the Clou... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- Table Functions 7856
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...type type ); void duckdb_table_function_set_extra_info ( duckdb_table_function table_function , void * extra_info , duckdb_delete_callback_t destroy ); void duckdb_table_function_set_bind ( duckdb_table_function table_function , duckdb_table_function_b...b_bind_info info , const char * name ); void duckdb_bind_set_bind_data ( duckdb_bind_info info , void * bind_data , duckdb_delete_callback_t destroy ); void duckdb_bind_set_cardinality ( duckdb_bind_info info , idx_t cardinality , bool is_exact ); void...et_bind_data ( duckdb_init_info info ); void duckdb_init_set_init_data ( duckdb_init_info info , void * init_data , duckdb_delete_callback_t destroy ); idx_t duckdb_init_get_column_count ( duckdb_init_info info ); idx_t duckdb_init_get_column_index ( d... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
DuckDB 2.0 Documentation / man.mtool.work