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

     1  ---
     2  layout: default
     3  title: Replace Query - Reference Manual - csvq
     4  category: reference
     5  ---
     6  
     7  # Replace Query
     8  
     9  Replace query is used to insert or update records to a csv file.
    10  
    11  If records matching _key_columns_ exist, the records are updated. Otherwise, insert records.
    12  
    13  ## Insert or Update Values
    14  
    15  ```sql
    16  [WITH common_table_expression [, common_table_expression ...]]
    17    REPLACE INTO table_name
    18    [(column [, column ...])]
    19    USING (key_column [, key_column ...]))
    20    VALUES row_value [, row_value ...]
    21  ```
    22  
    23  _common_table_expression_
    24  : [Common Table Expression]({{ '/reference/common-table-expression.html' | relative_url }})
    25  
    26  _table_name_
    27  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }}) or [Table Object]({{ '/reference/select-query.html#from_clause' | relative_url }})
    28  
    29  _column_
    30  : [field reference]({{ '/reference/value.html#field_reference' | relative_url }})
    31  
    32  _key_column_
    33  : [field reference]({{ '/reference/value.html#field_reference' | relative_url }})
    34  
    35  _row_value_
    36  : [Row Value]({{ '/reference/row-value.html' | relative_url }})
    37  
    38  ## Insert or Update From Select Query
    39  
    40  ```sql
    41  [WITH common_table_expression [, common_table_expression ...]]
    42    REPLACE INTO table_name
    43    [(column [, column ...])]
    44    USING (key_column [, key_column ...]))
    45    select_query
    46  ```
    47  
    48  _common_table_expression_
    49  : [Common Table Expression]({{ '/reference/common-table-expression.html' | relative_url }})
    50  
    51  _table_name_
    52  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }}) or [Table Object]({{ '/reference/select-query.html#from_clause' | relative_url }})
    53  
    54  _column_
    55  : [field reference]({{ '/reference/value.html#field_reference' | relative_url }})
    56  
    57  _key_column_
    58  : [field reference]({{ '/reference/value.html#field_reference' | relative_url }})
    59  
    60  _select_query_
    61  : [Select Query]({{ '/reference/select-query.html' | relative_url }})