Help Center > > User Guide> MySQL Database Management (Standard Edition)> Table Management> Opening a Table

Opening a Table

Updated at: Mar 20, 2020 GMT+08:00

Prerequisites

You have logged in to the DAS console.

Scenarios

If the table has a primary key, you can add, delete, modify, or query the table data as you do in Excel.

Procedure

  1. On the top menu bar, choose Database Management. On the displayed page, locate the target table and click Open.
  2. On the table details page, double-click a cell to edit data. After adding or editing data, submit and save the changes.

    Table 1 Interface description

    Name

    Description

    Where Condition

    The WHERE clause is used to filter records.

    Quickly Generate Test Data

    Quickly generate test data for table structure testing and set rules.

    Copy Row

    Select the target row and then click Copy Row. The data of the row is copied.

    Copy Column

    Click the Copy Column drop-down list and select the column to be copied.

    Columns

    Allows you to filter the target columns.

    Display binary column as hexadecimal

    If the column content is displayed in binary, select this option. Otherwise, garbled characters are displayed.

    Refresh

    Allows you to update the table data manually.

    Detail

    Allows you to view detailed information of a specified row.

    Add

    Allows you to add rows.

    Submit

    Allows you to submit and save the changes to the data.

    Delete

    Allows you to delete the selected row of the table.

    Export

    Allows you to export the CSV or SQL file with a maximum of 10,000 records.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel