<bdo id='09i9W'></bdo><ul id='09i9W'></ul>
<i id='09i9W'><tr id='09i9W'><dt id='09i9W'><q id='09i9W'><span id='09i9W'><b id='09i9W'><form id='09i9W'><ins id='09i9W'></ins><ul id='09i9W'></ul><sub id='09i9W'></sub></form><legend id='09i9W'></legend><bdo id='09i9W'><pre id='09i9W'><center id='09i9W'></center></pre></bdo></b><th id='09i9W'></th></span></q></dt></tr></i><div id='09i9W'><tfoot id='09i9W'></tfoot><dl id='09i9W'><fieldset id='09i9W'></fieldset></dl></div>
<legend id='09i9W'><style id='09i9W'><dir id='09i9W'><q id='09i9W'></q></dir></style></legend>

<small id='09i9W'></small><noframes id='09i9W'>

    <tfoot id='09i9W'></tfoot>

    1. 是否可以从另一个 sql 脚本中的存储过程调用 sql 脚本?

      is it possible to call a sql script from a stored procedure in another sql script?(是否可以从另一个 sql 脚本中的存储过程调用 sql 脚本?)
            • <bdo id='wectA'></bdo><ul id='wectA'></ul>
            • <tfoot id='wectA'></tfoot>

            • <i id='wectA'><tr id='wectA'><dt id='wectA'><q id='wectA'><span id='wectA'><b id='wectA'><form id='wectA'><ins id='wectA'></ins><ul id='wectA'></ul><sub id='wectA'></sub></form><legend id='wectA'></legend><bdo id='wectA'><pre id='wectA'><center id='wectA'></center></pre></bdo></b><th id='wectA'></th></span></q></dt></tr></i><div id='wectA'><tfoot id='wectA'></tfoot><dl id='wectA'><fieldset id='wectA'></fieldset></dl></div>
              1. <small id='wectA'></small><noframes id='wectA'>

                <legend id='wectA'><style id='wectA'><dir id='wectA'><q id='wectA'></q></dir></style></legend>

                  <tbody id='wectA'></tbody>
                本文介绍了是否可以从另一个 sql 脚本中的存储过程调用 sql 脚本?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                问题描述

                我想使用 .像这样从存储过程中调用 sql 脚本......

                I'd like to use . to call sql script from inside a stored proc like so...

                delimiter ///
                create procedure append_procedure()
                BEGIN
                . test.sql;    
                END; ///
                delimiter ;
                

                我收到无法打开'test.sql;'" 以这种方式运行时出错.我也试过了!但后来我收到了一个权限被拒绝的错误.但是,我无法消除 ;或者整个东西都坏了.有没有办法解决这个问题?

                I'm getting a "failed to open 'test.sql;' " error when I run it this way. I've also tried ! but then I get a permission denied error. However, I can't eliminate the ; or the whole thing is broken. Is there a way around this?

                我做错了什么?

                推荐答案

                有一组内置于 mysql 客户端的命令.它们记录在 "mysql命令."其中包括 DELIMITER、SOURCE、HELP、CONNECT、USE、QUIT 等.

                There is a set of commands that are builtin to the mysql client. They're documented under "mysql Commands." These include DELIMITER, SOURCE, HELP, CONNECT, USE, QUIT, etc.

                .(或 SOURCE)命令是这些内置命令之一.您不能以编程方式执行这些内置命令,也不能从存储过程中执行.

                The . (or SOURCE) command is one of these builtins. You can't execute these builtin commands programmatically, nor from within a stored procedure.

                这就像尝试使用 execl() 从 C 程序运行内置的 UNIX shell.

                It'd be like trying to run a UNIX shell builtin from a C program using execl().

                一个不同的类比可能是在网络浏览器中,您可以在其中输入由浏览器应用程序本身处理的特殊请求,例如about:";这些不会导致对远程网站的任何 HTTP 请求.

                A different analogy might be in a web browser, where you can type in special requests like "about:" that are handled by the browser app itself; these don't result in any HTTP request to a remote web site.

                此外,如果您可以从存储过程中获取脚本也无济于事,因为脚本本身可能包含一堆 mysql 客户端内置命令,因此无法由存储过程运行.

                Also, it wouldn't help if you could source a script from within a stored procedure, because the script itself likely contains a bunch of commands that are mysql client builtins, and thus cannot be run by the stored proc.

                另见我对这些相关问题的回答:

                See also my answers to these related questions:

                • 在 PHP 中运行 MySQL *.sql 文件
                • 从 PHP 内加载 .sql 文件莉>
                • PHP:多个 SQL 查询合二为一mysql_query 语句

                这篇关于是否可以从另一个 sql 脚本中的存储过程调用 sql 脚本?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                相关文档推荐

                Accessing another user#39;s table within an Oracle Stored Procedure(在 Oracle 存储过程中访问另一个用户的表)
                How to View Oracle Stored Procedure using SQLPlus?(如何使用 SQLPlus 查看 Oracle 存储过程?)
                How to Pass Java List of Objects to Oracle Stored Procedure Using MyBatis?(如何使用 MyBatis 将 Java 对象列表传递给 Oracle 存储过程?)
                Set the variable result, from query(设置变量结果,来自查询)
                What is dynamic SQL?(什么是动态 SQL?)
                Mysql - How to quit/exit from stored procedure(Mysql - 如何退出/退出存储过程)
                  <bdo id='88d6n'></bdo><ul id='88d6n'></ul>

                  <small id='88d6n'></small><noframes id='88d6n'>

                  1. <legend id='88d6n'><style id='88d6n'><dir id='88d6n'><q id='88d6n'></q></dir></style></legend>

                      <tfoot id='88d6n'></tfoot>

                    1. <i id='88d6n'><tr id='88d6n'><dt id='88d6n'><q id='88d6n'><span id='88d6n'><b id='88d6n'><form id='88d6n'><ins id='88d6n'></ins><ul id='88d6n'></ul><sub id='88d6n'></sub></form><legend id='88d6n'></legend><bdo id='88d6n'><pre id='88d6n'><center id='88d6n'></center></pre></bdo></b><th id='88d6n'></th></span></q></dt></tr></i><div id='88d6n'><tfoot id='88d6n'></tfoot><dl id='88d6n'><fieldset id='88d6n'></fieldset></dl></div>

                          <tbody id='88d6n'></tbody>