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

     1  ---
     2  layout: default
     3  title: Insert Query - Reference Manual - csvq
     4  category: reference
     5  ---
     6  
     7  # Insert Query
     8  
     9  Insert query is used to insert records to a csv file.
    10  
    11  ## Insert Values
    12  
    13  ```sql
    14  [WITH common_table_expression [, common_table_expression ...]]
    15    INSERT INTO table_name
    16    [(column [, column ...])]
    17    VALUES row_value [, row_value ...]
    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  _row_value_
    30  : [Row Value]({{ '/reference/row-value.html' | relative_url }})
    31  
    32  ## Insert From Select Query
    33  
    34  ```sql
    35  [WITH common_table_expression [, common_table_expression ...]]
    36    INSERT INTO table_name
    37    [(column [, column ...])]
    38    select_query
    39  ```
    40  
    41  _common_table_expression_
    42  : [Common Table Expression]({{ '/reference/common-table-expression.html' | relative_url }})
    43  
    44  _table_name_
    45  : [identifier]({{ '/reference/statement.html#parsing' | relative_url }}) or [Table Object]({{ '/reference/select-query.html#from_clause' | relative_url }})
    46  
    47  _column_
    48  : [field reference]({{ '/reference/value.html#field_reference' | relative_url }})
    49  
    50  _select_query_
    51  : [Select Query]({{ '/reference/select-query.html' | relative_url }})