	©	SQL :: Manager
				Home	Program Information	Technical details	Free download	Donate for a cup of coffee

Management and editing of MySQL and MariaDB tables

The table managing and editing module can be reached by selecting Tables of the database in the main menu

Module for managing and editing tables in MySQL and MariaDB databases:

Tables can be filtered alphabetically or by search.

Tables can be selected for export or actions.

The list can be sorted by clicking on the column headings of the table list.

A backup archive is available.

MySQL tables can be created in different ways.

Moreover, there are modules for editing the table structure, as well as output and editing of data.

	Reloads table menu and list.
	Displays the menu for alphabetical selection of tables.
	Starts form for creating new tables.

	Searching in table names, with %... inside the table names.
	Searching in table column names.
	Searching in index names, with %... inside the index names.

	Displays the action module for selected tables (Export, Save, Delete, Empty).
	Shows the export module for all tables.
	Saves the creation scripts of all tables to the archive.
	Shows the script archive.

Buttons in table list:

Structure:	Opens the form for editing the table.
Data:	Displays data of tables with SQL statement.
Script:	Displays the table creation script in the SQL editor.
Download:	Downloads the table creation script.
Delete:	Deletes the table.

Icons in the table menu:

	Displays data of tables with SQL statement.
	Opens the data wizard for the table.
	Displays the table creation script in the SQL editor.
	Opens the form for editing the table.

Export and action module for selected tables.

Table definition: Creation scripts of the tables are created.

Index definition: The index generation of the tables is created.

Trigger definition: The trigger generations of the tables are created.

Table data: The table data is exported.

CREATE, CREATE IF NOT EXISTS, DROP & CREATE, CREATE OR REPLACE: Selection of the creation option for creation scripts of the tables. CREATE OR REPLACE: MariaDB databases only.

Filename: Filename for export files.

Delimiter: Program codes from triggers are enclosed in delimiters.

Append file name to individual files: The specified file name is also included in the individual file export.

Database name in file names: The database name is included in the file names.

Output single files with delimiters: When exporting triggers to individual files, the program code is enclosed in delimiters.

GZIP compression: Files are exported or backed up GZip compressed.

Show selected tables as text: The export file is shown as text in the SQL editor.

Download selected tables in one file: Only one export file with the given name containing all scripts will be downloaded.

Download selected tables as individual files: A separate export file is downloaded for each table.

Save selected tables: Tables are saved in the script archive of the MyWAY SQL Manager.

Clear selected tables: All data in the tables will be deleted (TRUNCATE).

Delete selected tables: Tables will be deleted from the MySQL server (DROP).

Invert Selection: Inverts the selection markers.

Export module for all tables.

Table definition: Creation scripts of all tables are created.

Index definition: The index generations of all tables are created.

Trigger definition: The trigger generations of all tables are created.

Table data: The table data is exported.

CREATE, CREATE IF NOT EXISTS, DROP & CREATE, CREATE OR REPLACE: Selection of the creation option for creation scripts of all tables. CREATE OR REPLACE for MariaDB databases only.

Filename: Filename for export files of all tables.

Delimiter: Program codes from triggers are enclosed in delimiters.

Append file name to individual files: The specified file name is also included in the individual file export.

Database name in file names: The database name is included in the file names.

Output single files with delimiters: When exporting triggers to individual files, the program code is enclosed in delimiters.

GZIP compression: Files are exported or backed up GZip compressed.

Show all tables as text: The export file is shown as text in the SQL editor.

Download all tables in one file: Only one export file with the given name containing all scripts will be downloaded.

Download all tables as individual files: A separate export file is downloaded for each table.

Labeled menu by double-clicking title bar.

MySQL and MariaDB tables are the basic structure for storing data in relational databases. They are made up of rows and columns, with each row representing a record and each column representing a specific attribute or data field. A table is defined by its name and a set of columns. Each column has a name, a data type indicating the kind of data it can store, and optional constraints like NULL/NOT NULL, DEFAULT -Values.

A primary key is a column or combination of columns that uniquely identifies each row in the table. It ensures data integrity and provides a fast search mechanism. A foreign key establishes a relationship between two tables, enforcing referential integrity. It references the primary key of another table and ensures that the values in the foreign key columns match the values in the referenced primary key columns. Indexes are structures that improve the performance of data retrieval operations. They are created in one or more columns of a table, allowing for faster searching and sorting.

Tables allow inserting, updating and deleting data using SQL statements like INSERT, REPLACE, UPDATE and DELETE. The SELECT statement can be used to query tables to retrieve data based on specific criteria. Tables can be related to each other via primary key-foreign key relationships, which establish connections and enable data retrieval across multiple tables using joins.

MySQL and MariaDB provide various operations on tables, including creating tables with the CREATE TABLE statement, changing table structure with the ALTER TABLE statement, dropping tables using the DROP TABLE statement and TRUNCATE to remove all data.

MySQL and MariaDB support different storage engines like InnoDB, MyISAM, Federated and others that define how data is stored and accessed. Each storage engine has its own characteristics, performance considerations, and capabilities.

Tables form the core structure for organizing and storing data in relational databases. They provide a structured and efficient way to store and retrieve data, enforce data integrity through constraints, and establish relationships between entities in the database.

For more information on MySQL tables see: mysql.com and mariadb.com

Updated: 2023-09-15

2020-2024 Heino Cunze-Fischer