©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Create MySQL and MariaDB tables from CSV file

Creating MySQL and MariaDB tables from CSV data

MySQL table from CSV Table creation from CSV import is part of table management
Create new MySQL tables from CSV import
This module creates a new MySQL or MariaDB table from a CSV import:
Table head:
Name: Name of the new table.
Comment: Comment to be stored for the new table.
Next autoindex: First AUTOINCREMENT value for new table.
Engine: Database format of the new table.
Collation: Character set and collation of the new table.
Row format: Format in which the table rows should be managed in the database.
Import columns:
CSV field: Selection of which fields of the CSV file should be used for the import.
Column Name: Edit field names.
Column type: Editing of the field types. The field types are assigned automatically by analyzing the CSV file, but can be changed.
Length: Edit field lengths. The field lengths are automatically calculated by analyzing the CSV file, but can be changed. The minimum lengths are specified for character strings.
Editing can be activated for all field types, otherwise default values ​​are used.
Null Value: Specifies whether NULL values ​​should be allowed for the fields.
Additional column options may appear:
Default value: Here you have the option of specifying standard values ​​for the fields.
Option: Field options according to field type.
Collation: Collation for string fields.
Comment: Comment for table field.
Index: Index creation for fields during table creation.
Combine: Specifies whether fields should be combined into an index.
Values: Shows the values ​​of the first 20 rows of the import file.
Import options:
Reload CSV file: Creation form is reloaded with the selected import options. If another CSV file is selected, it will be hoshloaded.
First row contains headings: The first line of the CSV file is used to name the field headings.
Field names in lower case: Field titles are in lower case.
Original names as column names: When loading this form, adopted field names are normalized. This can be prevented here.
Data import options:
Import data from CSV: The data from the CSV file is copied to the new table.
Get data from line: The data from the CSV file is copied to the new table from the specified line.
Accept data lines: The specified number of rows will be imported. The number of lines in the import file is calculated when the form is started.
Add auto increment: Add AUTO_INCREMENT value in this table specifying the name. A BIGINT value can also be selected for this. The default is INT.
Store empty strings as NULL: If NULL is allowed for the inherited field, otherwise store empty strings.
REPLACE instead of INSERT: Import option if a UNIQUE index is created for the table. The default is INSERT IGNORE
REPLACE causes the last data record to be used in the case of duplicate values.
Character encoding of the SCV file: Selection of the character encoding of the CSV file if it is to be converted.
Server options:
Data directory target table: Path to the directory on the server where the data files are to be saved.
Index directory target table: Path to the directory on the server in which the index files are to be stored (MyISAM only).
Create table in database: Table is created and displayed in the menu. An import log is output.
Download generation as SQL script: The creation of the table and data import are downloaded in a SQL file.
Table creation as SQL script Not available with this function
Create table Not available with this function
With this module MySQL and MariaDB tables can be created from CSV files. After selecting a CSV file, the structure and the data contained in the file are analyzed by the program. The program then makes a creation suggestion. Field assignments for the data, changes to data types, changes to character encoding and sorting, selection of additional data field options, selection of indices to be created and import settings can then be made using this form.

Instead of creating the table on a database, the SQL creation script can be downloaded as a file.
More information on creating MySQL tables can be found here: mysql.com and mariadb.com
Updated: 2023-09-21ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer