All Products
Search
Document Center

Reuse SQL statements

Last Updated: Jun 05, 2019

This section describes how to reuse SQL statements in Data Management Service (DMS).

Issue

SQL statements are used when you access a database. Simple SQL queries are easy to use. Rewriting SQL queries for complex data analysis or SQL queries that contain service logic is time-consuming. Even if you save these SQL queries to files, you have to maintain the files and you cannot use these SQL queries at anytime and anywhere.

Solution

You can use the My SQL feature to save frequently used SQL statements to DMS. As the SQL statements are not saved to local disks, you can use them in any databases or instances.