Use the Cmd Tab to execute SQL statements - Data Management - Alibaba Cloud - Data Management

This topic describes how to use the Cmd Tab in Data Management (DMS) to run SQL statements from a command-line interface. When you run a statement, the statement and its results appear at the top of the page.

Prerequisites

The target database must be a relational database, such as MySQL, Oracle, or SQL Server.
You must have query permissions on the target database or table. For information about how to apply for permissions, see permission management.

Procedure

Log in to DMS 5.0.
In the database instance list on the left, find your target database.
Double-click the database name to open the SQLConsole tab. For other ways to open the SQLConsole tab, see Go to the SQLConsole tab.
Right-click a blank area or a table name in the table list on the left, and then select Cmd Tab.

In the command execution area, enter your SQL statement, and then click Execute or press Ctrl+Enter.

For example, the following statement creates a test table named test_table01.

SQL statement to create the test_table01 table:

CREATE TABLE
 test_table01 (
 id INT NOT NULL AUTO_INCREMENT,
 name VARCHAR(50) NOT NULL,
 age INT NOT NULL,
 PRIMARY KEY (id)
 );

mysql>CREATE TABLE
  test_table01 (
    id INT NOT NULL AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    age INT NOT NULL,
    PRIMARY KEY (id)
  );
- - -Executing (1) statement- - -
[Statement 1]:
CREATE TABLE
  test_table01 (
    id INT NOT NULL AUTO_INCREMENT,
    name VARCHAR(50) NOT NULL,
    age INT NOT NULL,
    PRIMARY KEY (id)
  )
[Success], Time elapsed: 10 (ms)
Affected rows: 0
Execution finished. (1) statement executed successfully.

Other operations

Click Clear screen to clear all content from the Cmd Tab.
The default entry mode is Use the editor. You can also click Use Textarea to switch to a plain text area.