Skip to main content

SQL Execution and Data Import/Export

Execute SQL

SQL statement execution is a basic feature provided by the MySQL database, enabling developers to process data stored in the database using fundamental SQL syntax, which offers greater flexibility compared to visual table editing methods.

How to Go to the SQL Execution Page

  1. Access Tencent Cloud Base/MySQL database
  2. Select the environment's default database instance and click Database Settings

3. Create an account and password. In the pop-up dialog box, enter the account name, host, password, and other information.

  1. Click the Database Configuration button to go to the DMC tool page, and enter the previously created account and password to log in.

  1. After going to the DMC tool, select SQL Window to go to the execution panel and edit SQL statements.

Import/Export

MySQL database provides import and export capabilities, enabling developers to perform data migration.

How to Go to the Import/Export Page

  1. Access Tencent Cloud Base/MySQL database
  2. Select the environment's default database instance and click Database Settings
  3. Refer to screenshots to perform import/export operations.