 Management and editing of MySQL and MariaDB databases. Information, statistics and tools |
 |
The database configuration can be reached by selecting the database in the main menu | |
|
|---|
 |
|
Module for managing and editing databases:
Information and statistics.
Permission editing.
Foreign key management and processing.
Data backup as SQL scripts and CSV files
Tools for converting and copying databases.
Deleting the database from the SQL server.
Execute SQL statements on databases.
Search databases for database objects (tables, views, procedures, functions, triggers and events).
|
 |
Displays information about the database. |
 |
Displays information and statistics about tables in the database. |
 |
Management of access rights of program users for this database. |
 |
Management of database user rights of this database. |
 |
Management of the foreign keys available for this database. |
 |
Module for backing up the database. |
 |
CSV backup of the database. |
 |
Module for database operations (change sorting, copy databse, delete rights). |
 |
Deleting the database from the connected server. |
 |
Opens the window for executing SQL statements on this database. |
|
 |
Search in definition names of database objects (tables, views, procedures, functions, triggers, events),
with %... inside the definition names. |
 |
Full-text search in definitions (table fields, views and program codes). |
|
 |
|
Labeled menu by double-clicking title bar.
|
MySQL and MariaDB databases are containers whitch owns collections of tables, views, stored procedures, user-defined functions, and other database items. A SQL server can manage multiple databases, each with its own elements.
Databases can be created using the CREATE DATABASE statement, specifying a unique name for the database. DROP DATABASE deletes a database, ALTER DATABASE changes database properties, and SHOW DATABASES lists all available databases. Tables within a database are organized in a schema that helps organize related tables and objects within a database. Multiple users with different permissions can be created and assigned to specific databases. This enables controlled access to data and ensures security. It is important to back up SQL databases regularly to protect against data loss.
MySQL and MariaDB allow operations affecting multiple databases within the same server, for example querying data using SELECT b> from different databases in a single query or creating views that reference tables from different databases. |
| | For more information on MySQL databases, see: and |
|
|
|
