is it possible to call a sql script from a stored procedure in another sql script?

by

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.

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

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

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.

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:

More Related Contents:

  1. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  2. Can I create view with parameter in MySQL?
  3. Pass array to MySQL stored routine
  4. Connect By Prior Equivalent for MySQL
  5. MySQL stored procedure vs function, which would I use when?
  6. MySQL stored procedures use them or not to use them
  7. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  8. MySQL create stored procedure syntax with delimiter
  9. mysql dynamic query in stored procedure
  10. Writing optional parameters within stored procedures in MySQL? [duplicate]
  11. Dynamic table names in stored procedure function
  12. List of Stored Procedures/Functions Mysql Command Line
  13. passing LIMIT as parameters to MySQL sproc
  14. mysql stored procedure that calls itself recursively
  15. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  16. How do you debug MySQL stored procedures?
  17. Bash script to insert values in MySQL
  18. How can I use transactions in my MySQL stored procedure?
  19. MySQL Stored Procedure Error Handling
  20. MySQL Stored Procedures not working with SELECT (basic question)
  21. use a variable for table name in mysql sproc
  22. Split a string and loop through values in MySQL stored procedure
  23. How to schedule a stored procedure in MySQL
  24. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  25. MySQL : When stored procedure parameter name is the same as table column name
  26. What is dynamic SQL?
  27. How to use Table output from stored MYSQL Procedure
  28. Creating MYSQL Procedure in Laravel 4 Migrations
  29. Mysql stored procedure don’t take table name as parameter
  30. How to pass a variable to a IN clause?

Leave a Comment