After logging in to Database Management Center (DMC) Personal Edition, you can visually manage instances. Different database types support different operations. This document uses a MySQL instance as an example to introduce database management and table management.
Directions
Database Management
1. In the top menu bar, select Create > Create Database or click Database Management.
2. At the top of the page, click Create Database.
3. In the pop-up dialog box, enter the database name, select the character set and collation, and click OK.
Table Management
Creating a Table
1. In the top-left corner of the page, select the database where the table will be created.
2. In the top menu bar, select Create > Create Table or click
on the left side.
3. On the create table page, configure the basic table settings, including columns, indexes, foreign keys, and partition information, as prompted by the page. After you complete the configuration, click Submit, and then click OK in the pop-up dialog box.
Editing a Table
1. Edit table structure
In the left sidebar, hover over the table name, select Operations > Edit table structure, and modify the basic table information, column information, indexes, foreign keys, and partitions. After making the necessary changes, click Submit, and then click OK in the pop-up dialog box.
2. Edit table data
In the left sidebar, select the database and table, click the table name, and edit the table data. Once the modifications are complete, click Submit. In the pop-up dialog box, click Execution. In the Quick Operation on the right, you can filter and sort fields as needed.
SQL Operations
The SQL window provides users with an SQL editor, supporting common SQL templates and the ability to save custom SQL. It also supports displaying and exporting SQL results.
1. In the left sidebar, hover over the table name, select Operations > SQL Operation, or click the table name and select SQL Window from the top menu bar.
2. Enter and execute the SQL statement.
3. Click Save to store the current SQL statement in My Template.
