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

Import XML files and data into MySQL and MariaDB tables

Data import from XML The XML data import is part of the table editing
XML data import into MySQL tables
This module imports XML data into tables:
XML field: Fields of the XML file that can be used for the import.
Table field: Assignment of the table fields.
Values: Preview of the import values.
Reload XML file: Import form is reloaded with the selected import options. If another XML file is selected, it will be uploaded.
Get data from line: The data from the XML 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 XML file: Selection of the character encoding of the XML 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 is used to import data from XML files into MySQL and MariaDB tables. After selecting the file, the XML structure and the data it contains are analyzed by the program and an import suggestion is made if there is no saved schema. Field assignments and import settings can then be made here.

The import schema can be saved and will then be automatically suggested during the next import if the data field identifiers of the XML 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-2024 Heino Cunze-Fischer