Create Table Query
Create Table query is used to create new csv files.
Create Empty Table
CREATE TABLE [IF NOT EXISTS] file_path (column_name [, column_name ...])
- file_path
- identifier
- column_name
- identifier
If the IF NOT EXISTS clause is specified and the file already exists, no operation is performed. In this case, an error is raised if the specified columns are different from the existing file.
Create from the Result-Set of a Select Query
CREATE TABLE [IF NOT EXISTS] file_path [(column_name [, column_name ...])] [AS] select_query
- file_path
- identifier
- column_name
- identifier
- select_query
- Select Query
If the IF NOT EXISTS clause is specified and the file already exists, no operation is performed. In this case, an error is raised if the specified columns are different from the existing file.