Import File dialog
Table name, structure and data mappings
Item | Description |
|---|---|
Table | The name of the table. |
Comment | The table comment. |
Columns | Keys | Indexes | Foreign Keys | Data mappings and definitions of columns, keys, and indexes. Double-click the line to start editing. The Mapped to field specifies relation of a data column from the file and the corresponding column in the database. If you clear this field, no data is added to the target column in the database. To remove a column, select the corresponding line and click the Remove button |
.Data and DDL previews
Item | Description |
|---|---|
Data Preview | The generated preview of how your data will be imported to the database. |
DDL Preview | A statement or statements that PyCharm will run to create a table. You can edit the statements in the DDL preview field. |
Encoding, errors, and logs
Item | Description |
|---|---|
Encoding | Select the character encoding for your data in the source file. |
Write errors to file | Write errors that occur during the import in a text file. |
Insert inconvertible values as null | Insert the |