<p>You can perform SQL operations on a specific database in the SQL window.</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 perform SQL operations only on RDS MySQL and RDS PostgreSQL databases.</p> <p><strong><span style="font-size:18px">Procedures</span></strong></p> <ol> <li>Log in to the <a href="http://pinganyun.com/console/dms/login" target="_blank">DMS Console</a>.</li> <li>In the left navigation pane, click <strong>Quick Database Login</strong> to enter the <strong>Quick Database Login</strong> page.</li> <li>Click the target login tab, and then enter the domain name, port, database name, database username, and password.</li> <li>Click <strong>Log in Database</strong> to enter the <strong>Database Management</strong> page.</li> <li>Click the <strong>SQL Operation</strong> tab, and then select the target database in the right area of the page.</li> <li>In the SQL execution window, enter a SQL statement. This section uses the RDS MySQL database as an example.</li> <li>Click <strong>Execute</strong>.</li> </ol> <p><strong><span style="font-size:18px">Result</span></strong></p> <p>The <strong>Execution Result</strong> area displays the execution result of the SQL statement.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20203006150323-1ff9f79b9190.png" style="height:307px; width:830px" /></p> <p><strong><span style="font-size:18px">Subsequent Procedures</span></strong></p> <p>1.&nbsp; In the <strong>Results</strong> area, select the target data line, and then click <strong>Single line details</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20203006150416-17ac421c9b87.png" style="height:140px; width:830px" /></p> <p>2.&nbsp; On the <strong>Single line details </strong>page that opens, view detailed information about the selected data line.</p> <p>&nbsp;<img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20203006150517-113fc04f9a56.png" style="height:211px; width:617px" /></p>