©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Import CSV data into MySQL, MariaDB tables

Import CSV files and data into MySQL and MariaDB tables

Data import from CSV The CSV data import is part of the table editing
CSV data import into MySQL tables
This module imports CSV data into tables:
CSV field: Fields of the CSV file that can be used for the import.
Table field: Assignment of the table fields.
Values: Preview of the import values.
Reload CSV file: Import form is reloaded with the selected import options. If another CSV file is selected, it will be uploaded.
First row contains headings: The first line of the CSV file is used to map the field headings and omit for import.
Get data from line: The data from the CSV file is copied to the new table from the specified line.
Accept data rows: The specified number of rows will be imported. The number of lines in the import file is calculated when the form is started.
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 CSV file: Selection of the character encoding of the CSV file if it is to be converted.
Save import scheme: The field mappings are saved. With the next import with the same file format, these are automatically adopted.
This module allows you to import data from CSV files into MySQL and MariaDB tables. After selecting the file, the program analyzes it and makes an import suggestion if there is no saved schema. Field assignments and import settings can then be made here.

The import schema can be saved and will be automatically suggested during the next import if the data field identifiers of the CSV file are the same.
More information on inserting data into MySQL tables can be found here: mysql.com and mariadb.com
Updated: 2023-09-21ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2023 Heino Cunze-Fischer