|
The table editing module is called in the table list | |
|
|
Module for editing MySQL tables:
|
| Display information and data of the table. |
| Create and delete table columns, indexes, partitions and data. |
| Edit table structure, table options, indexes, partitions, triggers, data and user permissions. |
| Tools for converting, copying and deleting data and structure. |
| Backup to the SQL script archive of table and manage files.
|
| The order of the table columns can be changed by drag & drop. |
|
Table head: |
Name: | Name of the new table |
Comment: | Comment to be stored for the table. |
Next autoindex: | First AUTOINCREMENT value for the table. |
Engine: | Database format of the table. |
Collation: | Character set and collation of the table. |
Row format: | Format in which the table rows should be managed in the database. |
|
Table columns: |
Name: | Column name |
P/S: | Primary or spatial index of the table. |
U: | Unique indexes to which the table column is linked. |
I: | Simple indexes to which the table column is linked. |
F: | Full-text indexes to which the table column is linked. |
Type: | Data type of the column. |
Length/Value: | Storage size or format of the data type. |
Default value: | Default value of the table column that should be inserted if the column is not described when a data record is created. Character strings must be enclosed in quotes. MariaDB also allows functions here. |
NULL: | column accepts NULL values. |
Option: | Data type options. For character strings, the character encoding. |
Sorting: | Collation assignment to character set. |
Extra: | Extra options for data column (AUTO_INCREMENT, ON UPDATE CURRENT_TIMESTAMP). |
Comment: | Comment to be stored for the data column.
|
Create fields after: | Number of new columns to be added from the specified position. |
|
|
Table is reloaded. |
|
Display table information. |
|
View and edit table data. |
|
Data wizard to view and edit data. |
|
Display form for inserting new data records. |
|
Module to import data into MySQL table. |
|
View and edit table indexes. |
|
View and edit the foreign keys the table is related to. |
|
View and edit triggers on the table. |
|
Creation and editing of table partitions.. |
|
Editing table options. |
|
Edit database user permissions to table. |
|
|
Output table changes as an SQL script in the SQL editor. |
|
Save table changes. |
|
|
Save table definition and data in the archive. |
|
Download table definition and data. |
|
Display table archive. |
|
|
Display table tools. |
|
Display elete functions. |
|
|
Labeled menu by double-clicking title bar.
|
Save table definition and data to archive: |
|
Saving the table creation script and data to the MyWAY SQL Manager archive.
|
Table definition: | Table creation script is saved. |
Table data: | Table data is saved as a SQL script. |
GZIP: | Files are saved with GZip compression. |
|
Download table definition and data: |
|
Download the table creation script and data.
|
Table definition: | Download the table creation script. |
Table data: | Download the table data. |
GZIP: | Files are downloaded with GZip compression. |
|
Symbols in table columns: |
|
Table column in primary index. By clicking, the index is displayed and can be edited. |
|
Table column in spatial index. By clicking, the index is displayed and can be edited. |
|
Table column in unique indexes. By clicking, the indexes will displayed and can be edited. |
|
Table column in normal indexes. By clicking, the indexes will displayed and can be edited. |
|
Table column in fulltext indexes. By clicking, the indexes will displayed and can be edited. |
|
Shows the number of indexes in which the table field exists. By clicking, the indices are displayed and can be edited. |
|
|
Add table column to table at position. |
|
Delete table column from table. |
|
Functions for selected table columns: |
View: | Selected columns are shown as data. |
Index: | Table columns are transferred to a new index. |
Unique: | Table columns are transferred to a new unique index. |
Full text: | Table columns are transferred to a new full-text index. |
Spatial: | Table columns are included in a new spatial index. |
Primary key: | Table columns are included in a primary index. |
Delete: | Table columns are deleted. |
Reverse the marking: | The selection is inverted. |
|