Reuse a SQL Statement

<p>This feature improves the execution efficiency of SQL statements.</p> <p><strong><span style="font-size:18px">Prerequisites</span></strong></p> <p>1.&nbsp; 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>2.&nbsp; You have successfully saved SQL statements. For more information, see <a href="http://pinganyun.com/ssr/help/database/DMS/5d5f4c9be9ca5f712e340eb8.5d5f55b6e9ca5f712e340eb9.5d5f5741e9ca5f712e340eba" target="_blank">Save a SQL Statement</a>.</p> <p><strong><span style="font-size:18px">Usage Guidelines</span></strong></p> <p>You can reuse only SQL statements of the RDS MySQL and RDS PostgreSQL databases.</p> <p><strong><span style="font-size:18px">Procedures</span></strong></p> <p>1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Log in to the <a href="http://pinganyun.com/console/dms/login" target="_blank">DMS Console</a>.</p> <p>2.&nbsp;&nbsp;&nbsp;&nbsp;&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;&nbsp;&nbsp;&nbsp;&nbsp; Click the target login tab, and then enter the domain name, port, database name, database username, and password.</p> <p>4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click <strong>Log in Database</strong> to enter the <strong>Database Management</strong> page.</p> <p>5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click the <strong>SQL Reuse</strong> tab.</p> <p>6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In the <strong>Operations</strong> column of the target SQL, click <strong>Execute</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607154349-1666844c92b3.png" style="height:179px; width:830px" /></p> <p><strong><span style="font-size:18px">Result</span></strong></p> <p>The <strong>SQL Operation</strong> tab displays the SQL statement that has been saved. This section uses the RDS MySQL database as an example.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607154412-1edf22629b18.png" style="height:293px; width:830px" /></p> <p>&nbsp;</p>
Did the above content solve your problem? Yes No
Please complete information!

Call us

400-151-8800

Email us

cloud@pingan.com

Online customer service

Instant reply

Technical Support

cloud products