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

     1  ---
     2  layout: default
     3  title: Update Query - Reference Manual - csvq
     4  category: reference
     5  ---
     6  
     7  # Update Query
     8  
     9  Update query is used to update records on csv files.
    10  
    11  ## Update in a single file
    12  
    13  ```sql
    14  [WITH common_table_expression [, common_table_expression ...]]
    15    UPDATE table_name
    16    SET column = value [, column = value ...]
    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 }}) or [Table Object]({{ '/reference/select-query.html#from_clause' | relative_url }})
    25  
    26  _column_
    27  : [field reference]({{ '/reference/value.html#field_reference' | relative_url }})
    28  
    29  _value_
    30  : [value]({{ '/reference/value.html' | relative_url }})
    31  
    32  _where_clause_
    33  : [Where Clause]({{ '/reference/select-query.html#where_clause' | relative_url }})
    34  
    35  ## Update in multiple files
    36  
    37  ```sql
    38  [WITH common_table_expression [, common_table_expression ...]]
    39    UPDATE table_name [, table_name ...]
    40    SET column_name = value [, column_name = value ...]
    41    from_clause
    42    [where_clause]
    43  ```
    44  
    45  _common_table_expression_
    46  : [Common Table Expression]({{ '/reference/common-table-expression.html' | relative_url }})
    47  
    48  _table_name_
    49  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }})
    50    
    51    _table_name_ is not a file path, it is any one of table name aliases specified in _from_clause_. 
    52  
    53  _column_name_
    54  : [field reference]({{ '/reference/value.html#field_reference' | relative_url }})
    55  
    56  _value_
    57  : [value]({{ '/reference/value.html' | relative_url }})
    58  
    59  _from_clause_
    60  : [From Clause]({{ '/reference/select-query.html#from_clause' | relative_url }})
    61  
    62  _where_clause_
    63  : [Where Clause]({{ '/reference/select-query.html#where_clause' | relative_url }})