1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
UPDATE table_name SET column1 = value1, column2 = value2 WHERE a=1;
UPDATE table_name SET column1 = value1, column2 = value2 WHERE a=1 RETURNING *;
UPDATE table_name SET column1 = value1, column2 = value2 WHERE a=1 RETURNING id foo, id_2 AS bar;
UPDATE OR IGNORE table_name SET column1 = value1, column2 = value2 WHERE a=1;
UPDATE OR ABORT table_name SET column1 = value1, column2 = value2 WHERE a=1;
UPDATE OR FAIL table_name SET column1 = value1, column2 = value2 WHERE a=1;
UPDATE OR REPLACE table_name SET column1 = value1, column2 = value2 WHERE a=1;
UPDATE OR ROLLBACK table_name SET column1 = value1, column2 = value2 WHERE a=1;
UPDATE table_name SET (context, country) = (SELECT context, country FROM Nations);
|
