Results of 1 - 1 of about 1 for Anna (0.001 sec.)
- MERGE INTO Statement 9414
- 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
...table. CREATE TABLE people (id INTEGER, name VARCHAR, salary FLOAT); INSERT INTO people VALUES (1, 'John', 92_000.0), (2, 'Anna', 100_000.0); The simplest upsert would be to use a whole row in the USING clause. This way, if there is a match, the row...eople.id) WHEN MATCHED THEN UPDATE WHEN NOT MATCHED THEN INSERT; FROM people ORDER BY id; id name salary 1 John 105000.0 2 Anna 100000.0 3 Sarah 95000.0 In the previous example we are updating the whole row if id matches. However, it is also a common...(id) WHEN MATCHED THEN UPDATE SET salary = salary_updates.salary; FROM 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... - https://man.mtool.work/duckdb/2.0/sql/statements/merge_into.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work