Search Result: Lyon - DuckDB 2.0 全文検索

UPDATE Statement 9414: The UPDATE statement modifies the values of rows in a table. Examples For every row where i is NULL , set the value to 0 instead: UPDATE tbl SET i = 0 WHERE i IS NULL; Set all values of i to 1 and all values of j to 2: UPDATE tbl SET i = 1, ... alue 2 Multiple Matching Source Rows If a target row matches multiple rows in the FROM clause, the target row is updated only once, using the values of one of the matching source rows. Which source row is used is not specified. For example, the follo ... country_code VARCHAR); CREATE TABLE country (code VARCHAR, name VARCHAR); INSERT INTO city VALUES ('Paris', 700, 'FR'), ('Lyon', 200, 'FR'), ('Brussels', 400, 'BE'); INSERT INTO country VALUES ('FR', 'France'), ('BE', 'Belgium'); To increase the rev ... E city.country_code = country.code AND country.name = 'France'; SELECT * FROM city; name revenue country_code Paris 800 FR Lyon 300 FR Brussels 400 BE Upsert (Insert or Update) See the Insert documentation for details. ...; https://man.mtool.work/duckdb/2.0/sql/statements/update.html

PREV 1 NEXT

DuckDB 2.0 Documentation / man.mtool.work