是否可以从另一个 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 脚本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！