<section class="section attention"> <p class="p">执行已保存的SQL语句，避免执行前重新编写，提升效率。</p> <p class="p"><strong class="ph b">前提条件</strong></p> <p class="p">您已成功保存SQL语句，可参考<a class="xref" href="https://www.ocftcloud.com/ssr/help/database/DMS/user_guide.SQL_operation.save_sql" target="_blank" rel="external noopener">保存SQL</a>。</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="sql_reuse__ol_rzg_k5j_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 Console页面，选择SQL复用页签。</li> <li class="li">单击目标SQL操作列的执行SQL，跳转至SQL操作页面。<p class="p"><strong class="ph b">说明: </strong>本文以RDS-MySQL为例。</p><p class="p"><img class="image" id="sql_reuse__image_szc_vlk_hrb" src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20212010155605-1fafe3d79539.png"></p></li> </ol> <p class="p"><strong class="ph b">执行结果</strong></p> <p class="p">在<strong class="ph b">SQL操作</strong>页面，可查看并编辑保存的SQL语句。 <img class="image" id="sql_reuse__image_nzb_wlk_hrb" src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20212010155605-1ba6339e94fe.png"></p> <p class="p"><strong class="ph b">后续操作</strong></p> <p class="p">单击<strong class="ph b">格式化</strong>，可参考<a class="xref" href="https://www.ocftcloud.com/ssr/help/database/DMS/user_guide.SQL_operation.format_sql" target="_blank" rel="external noopener">格式化SQL</a>； 或者单击<strong class="ph b">执行</strong>，执行SQL，可参考<a class="xref" href="https://www.ocftcloud.com/ssr/help/database/DMS/user_guide.SQL_operation.execute_SQL" target="_blank" rel="external noopener">执行SQL</a>。</p> <p class="p"> </p> </section>