SQL Operations
Download
Focus Mode
Font Size
SQL operations executed in the SQL execution panel provide a graphical SQL editor with predefined SQL templates and support for user-defined SQL execution. This allows users to efficiently query and manage database data through an intuitive interface.
Use Limits
If a TDSQL-C for MySQL read-only analysis instance contains unsupported data types, an error will occur when executing SQL queries. For unsupported data types, see Compatibility Note.
Prerequisites
SQL Execution Panel Operations
1. Access the SQL execution panel using the following methods.
After you successfully log in to the instance, the execution panel will be displayed on the right side of the page.
Hover over the database name, select Operation > SQL operation, and enter the execution panel for the selected database.
Hover over the table name, select Operations > SQL operation, and enter the execution panel for the selected table.
Hover over the view name, select Operation > SQL operation, and enter the execution panel for the selected view.
2. Enter the SQL statement, and perform the following operations as needed.
Note:
In the right panel, go to My Commands > System Template, select a template SQL statement, and modify it as needed.
Kill the current session and reinitialize: Click Terminate Session at the top of the page.
View the SQL execution plan: Click Execution Plan at the top of the page.
Optimize the SQL format: Click Format Optimization at the top of the page.
Save the command: Click Favorite at the top of the page. In the pop-up window, enter a name, select the applicable scope, and click Confirm.
You can click My Commands in the upper-right corner of the page and select My Favorites to view the favorited command templates.
Clear the currently entered SQL statement: Click Clear at the top of the page.
3. After entering the SQL statement, click Execute to view the execution results.
Click Export Result to Export Current Page CSV, Export Current Page SQL, or Export Full Data.
Click Enable Editing to directly add or delete data records.
AI Panel SQL Operations
1. Click 
2. In the AI Panel, select the associated database and associated table, enter a problem description to generate an SQL statement, and click 
3. In the SQL statement section, click Execute.
4. View the SQL execution results.
Click Export Result to Export Current Page CSV, Export Current Page SQL, or Export Full Data.
Click Enable Editing to directly add or delete data records.
Help and Support
Was this page helpful?
You can also Contact sales or Submit a Ticket for help.
Help us improve! Rate your documentation experience in 5 mins.
Feedback