©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 JSON

Creating MySQL and MariaDB tables from JSON array

MySQL table from JSON array Table creation from JSON array import is part of table management
Create new MySQL tables from JSON array import
This module creates a new MySQL or MariaDB table from a JSON array 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:
JSON field: Selection of which fields of the JSON 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 JSON file, but can be changed.
Length: Edit field lengths. The field lengths are automatically calculated by analyzing the JSON 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 JSON file: Creation form is reloaded with the selected import options. If another JSON file is selected, it will be hoshloaded.
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.
Converting one-dimensional arrays: For one-dimensional JSON arrays, the index of each field is taken as the field header.
Adopt array index as field: Array indices are adopted as an additional field in the new table.
Data import options:
Import data from JSON: The data from the JSON file is copied to the new table.
Get data from line: The data from the JSON 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 JSON file: Selection of the character encoding of the JSON 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 JSON arrays and files. After selecting a file or entering a JSON script, the structure of the JSON array and the data it contains are analyzed by the program. It then uses the result to make a creation suggestion. Here you can then make field assignments for the data, changes to data types and character encoding and sorting, selection of additional data field options, selection of the indexes to be created and import settings.

Instead of generating on the server, the SQL generation 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-2023 Heino Cunze-Fischer