Update Query
Update query is used to update records on csv files.
Update in a single file
[WITH common_table_expression [, common_table_expression ...]]
UPDATE table_name
SET column = value [, column = value ...]
[where_clause]
- common_table_expression
- Common Table Expression
- table_name
- identifier or Table Object
- column
- field reference
- value
- value
- where_clause
- Where Clause
Update in multiple files
[WITH common_table_expression [, common_table_expression ...]]
UPDATE table_name [, table_name ...]
SET column_name = value [, column_name = value ...]
from_clause
[where_clause]
- common_table_expression
- Common Table Expression
- table_name
- identifier
table_name is not a file path, it is any one of table name aliases specified in from_clause.
- column_name
- field reference
- value
- value
- from_clause
- From Clause
- where_clause
- Where Clause