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

Import JSON files and data into MySQL and MariaDB tables

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

The import schema can be saved and it will be automatically suggested the next time you import if the data field identifiers of the JSON data are the same.
Information about JSON functions in SQL statements can be found here: Mysql and MariaDB JSON functions
Updated: 2023-09-23ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer