Skip to content
Docs
Connection-manage
Table data related operations

Related operations on table data

For a series of operations on the table, we will introduce them separately:

'total'

  • Open Table: open the table structure to view data
  • Query console: Create a new console based on this database
  • Pin: pin list
  • Copy name: copy the table name
  • View DDL: View the DDL statements of the table
  • Copy table: Copy the table. You can choose to copy the table structure and table data
  • Truncate Table: Clear the table
  • Edit Table: Edit the table (table name, comments, column names, primary key...)
  • Export as SQL file: Export to SQL file. You can choose to export the table structure and table data
  • Import Data: Import files in CSV, XLSX, XLS, SQL format
  • Export Data: Export data files in CSV, XLSX, XLS, SQL format
  • Delete Table: delete table
  • Generate Test Data: Generate test data for developers to use

View data

When you double-click a table in Database Explorer (View | Tool Windows | Database Explorer), the table, view, opens in the Data Editor. Or you can right-click the mouse to select the table you want to view and click Open Table to view it!

'visualization1'

Edit data

You can make modifications directly in the table. After modifying the data, submit it and the modification will be successful!

'update'

When our field names are too long to be modified or viewed directly from the table, we can select the data to be viewed or modified, then right-click and click View/Edit Data to view and edit the page.

'view and edit'

In addition, you can also view the DDL statements for specific modification operations:

'update2'

Refresh data

If you want to synchronize the data you see in the editor with the contents of the database, you need to reload the table view's data.

  • Click the refresh button on the toolbar.

'refresh1'

  • Right-click on the table and select Reload Page from the context menu.

'refresh2'

Row and row operations

'operations' When we select a row of data, right-clicking the mouse will perform the following operations:

  • Insert SQL: Copy the entire row of data into an Insert SQL statement

'Insert SQL'

  • Update SQL: Copy the entire row of data to the Update SQL statement

'Update SQL'

  • TAB delimited (data): copy the entire row of data

'TAB delimited'

  • TAB delimited (field name): Copy the field name corresponding to the entire row of data

'TAB delimited'

  • Tab-separated (field names and data): Copy the entire row of data and its corresponding field names

'TAB delimited'

  • Clone row: Clone the entire row of data

  • Delete row: delete the entire row of data

Tips:

  • If you want to copy multiple rows of data, please use Shift + left mouse button to select multiple rows for operation.
  • If you want to copy the entire row of data in the table, you can left-click the blank area in the upper left corner of the mouse to select all (as shown below)

'select all'

Table data operations

'operations2'

  • View/Edit Data: View/edit data
  • Copy: Copy selected single data
  • Copy the row as: Same as above...
  • Clone row: Clone row data
  • Set NULL: Set table data to null
  • Set DEFAULT: Set table data to default value
  • Delete row: delete row
Data resource managementUsing toolbar