执行SQL
<section class="section" id="execute_SQL__section_t2n_ztj_frb">
<p class="p">通过SQL操作窗口,可以对指定数据库执行SQL操作。</p>
<p class="p"><strong class="ph b">注意事项</strong></p>
<p class="p">仅RDS-MySQL和RDS-PostgreSQL支持SQL操作窗口。</p>
<p class="p"><strong class="ph b">操作步骤</strong></p>
<ol class="ol" id="execute_SQL__ol_qhb_twx_frb">
<li class="li">登录<a class="xref" href="https://www.ocftcloud.com/console/dms/login" target="_blank" rel="external noopener">DMS管理控制台</a>。</li>
<li class="li">单击左侧导航栏选择<strong class="ph b">非托管模式实例</strong>。</li>
<li class="li">选择目标数据库下的实例,选择<strong class="ph b">SQLConsole</strong>,填写<strong class="ph b">数据库名</strong>、<strong class="ph b">数据库账号</strong>以及<strong class="ph b">密码</strong>,单击<strong class="ph b">确定</strong>登录数据库,可参考<a class="xref" href="https://www.ocftcloud.com/ssr/help/database/DMS/quickstart.Login.rds_mysql.Unmanaged_mysql" target="_blank" rel="external noopener">登录数据库</a>。</li>
<li class="li">在SQL执行窗口,输入SQL语句。<p class="p">说明:本文以RDS-MySQL为例。</p><p class="p"><img class="image" id="execute_SQL__image_al4_vkk_hrb" src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20212010155605-19ce72d69082.png"></p></li>
<li class="li">单击<strong class="ph b">执行</strong>。<p class="p">在执行结果区域,可查看到本次SQL语句执行的结果。<img class="image" id="execute_SQL__image_kxz_wkk_hrb" src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20212010155605-1e35dc8c924d.png"></p></li>
</ol>
<ul class="ul" id="execute_SQL__ul_shb_twx_frb">
<li class="li">在执行结果区域,勾选目标行数据,单击<strong class="ph b">单行详情</strong>,进入单行详情页面。<img class="image" id="execute_SQL__image_xky_xkk_hrb" src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20212010155605-1c51d3389965.png"></li>
<li class="li">可查看此行数据的详细信息。<img class="image" id="execute_SQL__image_vjf_zkk_hrb" src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20212010155605-1dc9ae3f952b.png"></li>
</ul>
<p class="p"> </p>
</section>
提交成功!非常感谢您的反馈,我们会继续努力做到更好!