Execute a SQL statement

<p>Perform this task to execute SQL statements of a specific database in the command line window.</p> <p><strong><span style="font-size:18px">Prerequisites</span></strong></p> <p>You have successfully logged in to a database in the DMS console. 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>, <a href="http://pinganyun.com/ssr/help/database/DMS/5d5e6ce2e9ca5f712e340eb2.5d5f481e1c51aa7124c5e3f9.5d5f48ed1c51aa7124c5e3fb" target="_blank">Log in to an RDS PostgreSQL Database</a>, or <a href="http://pinganyun.com/ssr/help/database/DMS/5d5e6ce2e9ca5f712e340eb2.5d5f481e1c51aa7124c5e3f9.5d5f49b5e9ca5f712e340eb7" target="_blank">Log in to a DDS Database</a>.</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; Select 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>Command Line</strong> tab.</p> <p>6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Enter a SQL statement in the command line window. This section uses the RDS MySQL database as an example.</p> <p>7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Click <strong>Execute</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607164325-1771642c9918.png" style="height:666px; width:830px" /></p> <p><strong><span style="font-size:18px">Result</span></strong></p> <p>The command line window displays the SQL execution result.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200607164346-1024baf09437.png" style="height:713px; width:830px" /></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