tencent cloud

Feedback

DMC Management

Last updated: 2024-07-01 15:11:41
    This document describes the features of DMC, such as database/table creation, database management, instance session management, data import/export, and visualized table data editing.

    Creating Database

    1. By employing one of the following three login methods, log in to the DMC console.
    Directly log in to the DMC console.
    Or, log in to the TDSQL-C for MySQL console and click Log In in the Operation column in the cluster list (list view).
    Or, log in to the TDSQL-C for MySQL console, click the target cluster in the cluster list to enter the cluster management page, and click Log In in the top-right corner (tab view).
    2. On the navigation bar, select Create > Create Database > Create Database.
    
    
    3. In the pop-up window, configure the new database.Click OK to complete the creation process.
    
    Parameter
    Description
    Database Name
    Enter the database name, which can contain up to 64 characters, consisting of uppercase and lowercase letters, numbers, hyphens (-), and underscores (_), and must start with a letter and end with a letter or digit.
    Character Set
    Select the character set. Refer to the console for supported character sets.
    Collation
    After selecting the character set, the collation will be selected by default. Refer to the console for specific collations.

    Creating Table

    1. By employing one of the following three login methods, log in to the DMC console.
    Directly log in to the DMC console.
    Or, log in to the TDSQL-C for MySQL console and click Log In in the Operation column in the cluster list (list view).
    Or, log in to the TDSQL-C for MySQL console, click the target cluster in the cluster list to enter the cluster management page, and click Log In in the top-right corner (tab view).
    2. First, select the database in which you wish to create a table from the options on the left. Then, navigate to and select Create > Create Table from the navigation bar.
    3. On the page for creating a new table, after completing the necessary configurations as required, click Submit .
    
    Parameter
    Description
    Basic Information
    On the Basic Information Page, you need to set the table name, add remarks (optional), choose the storage engine (default is InnoDB; for other engines, refer to the actual console), set the character set, set validation rules, set row format, set average row length, set minimum row length, and set maximum row length.
    Column Information
    On the Column Information Page, you can use add, delete, insert, move up, and move down operations to configure the table's columns.
    Index
    On the Index Page, you can add new indexes. It helps quickly locate data rows with specific data values. Refer to the console for the specific supported index types and indexing methods.
    Foreign Key
    On the Foreign Key Page, you can add new foreign keys. Foreign keys are used to establish constraints on relationships between tables. A foreign key constraint specifies a column in one table whose values must match the values in a column of another table. This matched column is usually the primary key of the other table.
    Partition
    On the Partition Page, you can improve query performance and simplify data maintenance and management by dividing table data into multiple partitions.
    Note:
    For more information on the character set and sorting rule, see MySQL documentation.

    Database management

    Log in to the DMC console, select Database Management on the navigation bar at the top, and create, edit, or delete databases on the displayed page.
    
    

    Instance session management

    Log in to the DMC console, select Instance Session on the navigation bar at the top, and enter the instance session management page. You can view the details of all database sessions in the instance from four dimensions: session overview, users, access sources, and databases. DMC allows you to kill sessions, facilitating your session management.
    
    

    SQL window

    Log in to the DMC console, select SQL Window on the navigation bar at the top, or click SQL Operation on the Operation menu on the left sidebar to access the SQL window, which supports the following features:
    Run SQL commands and view results
    Optimize SQL statement formats
    View SQL command execution plans
    Save commonly used SQL statements
    Use SQL templates
    Export SQL statement execution results
    
    
    

    Import/Export

    Log in to the DMC console, select Import/Export > Data Importing or Data Exporting on the navigation bar at the top, and you can import data into or export data from a database.
    
    

    Visualized table data editing

    DMC for TDSQL-C for MySQL supports inserting, deleting, and updating data. You can click a table in the table list on the left sidebar to insert, delete, and update its data in batches in the right pane, and then click OK in the Quick Operation pane to preview the SQL statements and implement the modification.
    
    
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support