github.com/mithrandie/csvq@v1.18.1/docs/_posts/2006-01-02-delete-query.md (about)

     1  ---
     2  layout: default
     3  title: Delete Query - Reference Manual - csvq
     4  category: reference
     5  ---
     6  
     7  # Delete Query
     8  
     9  Delete query is used to delete records on csv files.
    10  
    11  ## Delete in a single file.
    12  
    13  ```sql
    14  [WITH common_table_expression [, common_table_expression ...]]
    15    DELETE
    16    FROM table_name
    17    [where_clause]
    18  ```
    19  
    20  _common_table_expression_
    21  : [Common Table Expression]({{ '/reference/common-table-expression.html' | relative_url }})
    22  
    23  _table_name_
    24  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }})
    25  
    26  _where_clause_
    27  : [Where Clause]({{ '/reference/select-query.html#where_clause' | relative_url }})
    28  
    29  ## Delete in multiple files
    30  
    31  ```sql
    32  [WITH common_table_expression [, common_table_expression ...]]
    33    DELETE table_name [, table_name ...]
    34    from_clause
    35    [where_clause]
    36  ```
    37  
    38  _common_table_expression_
    39  : [Common Table Expression]({{ '/reference/common-table-expression.html' | relative_url }})
    40  
    41  _table_name_
    42  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }})
    43    
    44    _table_name_ is not a file path, it is any one of table name aliases specified in _from_clause_. 
    45  
    46  _from_clause_
    47  : [From Clause]({{ '/reference/select-query.html#from_clause' | relative_url }})
    48  
    49  _where_clause_
    50  : [Where Clause]({{ '/reference/select-query.html#where_clause' | relative_url }})