<p>Perform this task to save commonly used SQL statements with complicated analysis or service logic to avoid rewriting them in next executions.</p> <p><strong><span style="font-size:18px">Prerequisites</span></strong></p> <p>You have successfully logged in to a database. For more information, see <a href="http://pinganyun.com/ssr/help/database/DMS/5d5e6ce2e9ca5f712e340eb2.5d5f481e1c51aa7124c5e3f9.5d5f486b1c51aa7124c5e3fa" target="_blank">Log in to an RDS MySQL Database</a> or <a href="http://pinganyun.com/ssr/help/database/DMS/5d5e6ce2e9ca5f712e340eb2.5d5f481e1c51aa7124c5e3f9.5d5f48ed1c51aa7124c5e3fb" target="_blank">Log in to an RDS PostgreSQL Database</a>.</p> <p><strong><span style="font-size:18px">Usage Guidelines</span></strong></p> <p>You can save SQL statements only for RDS MySQL and RDS PostgreSQL databases.</p> <p><strong><span style="font-size:18px">Procedures</span></strong></p> <p>1.&nbsp; Log in to the <a href="http://pinganyun.com/console/dms/login" target="_blank">DMS Console</a>.</p> <p>2.&nbsp; In the left navigation pane, click <strong>Quick Database Login</strong> to enter the <strong>Quick Database Login</strong> page.</p> <p>3.&nbsp; Click the target login tab, and then enter the domain name, port, database name, database username and password.</p> <p>4.&nbsp; Click <strong>Log in Database</strong> to enter the <strong>Database Management</strong> page.</p> <p>5.&nbsp; Click the <strong>SQL Operation</strong> tab, and then select the target <strong>database</strong> in the right area of the page.</p> <p>6.&nbsp; In the SQL execution window, enter a SQL statement. This section uses the RDS MySQL database as an example.</p> <p>&nbsp; &nbsp;<img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20203006150824-113bf3079173.png" style="height:293px; width:830px" /></p> <p>7.&nbsp; Click <strong>Save</strong> to enter the <strong>Save</strong> page.</p> <p>8.&nbsp; Enter a title and an optional description.</p> <p>The title supports a maximum of 256 characters and the description supports a maximum of 400 characters.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20203006150926-157813909d00.png" style="height:321px; width:700px" /></p> <p>9.&nbsp; Click <strong>Confirm</strong>.</p> <p><strong><span style="font-size:18px">Result</span></strong></p> <p>The <strong>SQL Reuse</strong> tab displays the SQL statement that has been saved.</p> <p>&nbsp;<img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20203006151000-1c23e0e593a4.png" style="height:187px; width:830px" /></p>