©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
Create table in MySQL, MariaDB databases

Create table in MySQL and MariaDB SQL-databases

Create MySQL table This module is part of the table administration
Create new MySQL tables

This module provides 6 ways to create a new MySQL table in a database:

1. By defining the table fields.

2. By making a copy of another table on the SQL server (cloning).

3. By importing a CSV spreadsheet.

4. By importing an XML file.

5. By importing a JSON file.

6. By importing a PHP array.

Table creation as SQL script View and run table creation as SQL script
Create table Create the new table in the database
Create a new table by defining the table columns:
Create new MySQL table by field definition
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.
Sorting: Character set and collation of the new table.
Row Format: Format in which the table rows should be managed in the database.
 
Table columns:
Name: Column Name
P/S: A primary or spatial index is to be created from a column.
U: A unique index is to be created from column.
I: A simple index is to be created from column.
F: A simple full-text index is to be created from column.
Type: Data type of the column.
Length/Value: Storage size or format of the data type.
Default value: Default value of the data type.
Character strings must be enclosed in quotes.
MariaDB also allows functions here.
NULL: Column accepts NULL values.
Option: Data type options.
Sorting: Collation assignment for character string data types.
Extra: Extra options for data column (AUTO_INCREMENT, ON UPDATE CURRENT_TIMESTAMP).
Comment: Comment to be stored for the data column.
 
Table options:
Create fields after: Number of new columns to be created from the specified position.
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).
Add data column Add data column after this position.
Remove data column Remove data column from table builder.
Create new table by cloning:
Create new MySQL table by cloning
Source database: Selection of the database in which the source table is located.
Source table: Selection of the source table to copy from.
Apply data from source table: Copy data from source table to new table.
Apply options & indices: Apply table options and indexes to the new table.
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: Creates the new table by copy.
Create new table by import:
Create new MySQL table by importing
Text input: The import can be switched from file upload to text input.
 
Create table from CSV:
First line contains headings: The first line of the CSV file is used to name the field headings.
Copy data from CSV: The data from the CSV file is copied to the new table.
More information here: Table from CSV import
 
Create table from XML:
Transfer data from XML: The data from the XML file is copied into the new table. Otherwise only the field definitions are taken from the import.
More information here: Table from XML import
 
Create table from JSON:
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.
Transfer data from JSON: The data from the JSON file is copied into the new table. Otherwise only the field definitions are taken from the import.
More information here: Table from JSON import
 
Create table from PHP-Array:
Converting one-dimensional arrays: For one-dimensional PHP 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.
Transfer data from PHP: The data from the PHP array is copied into the new table. Otherwise only the field definitions are taken from the import.
More information here: Table from PHP import
 
Additional settings:
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: Proceed to import editor.
More information on creating MySQL tables can be found here: mysql.com and mariadb.com
More information about cloning MySQL tables can be found here: mysql.com and mariadb.com
Updated: 2023-09-17ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer