Delete Query
Delete query is used to delete records on csv files.
Delete in a single file.
[WITH common_table_expression [, common_table_expression ...]]
DELETE
FROM table_name
[where_clause]
- common_table_expression
- Common Table Expression
- table_name
- identifier
- where_clause
- Where Clause
Delete in multiple files
[WITH common_table_expression [, common_table_expression ...]]
DELETE table_name [, table_name ...]
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.
- from_clause
- From Clause
- where_clause
- Where Clause