NAMErun_file(): Executes a QueryScript from file.
This procedure accepts a server-side file name, containing a QueryScript text, and invokes the script.
run_file() is a convenience method. It merely refers to run(). Also note that run() may also accept file name as input, but has to guess that given input is indeed file name, whereas run_file() trusts input to be file name. with content of indicated file.
Invoker of this procedure must have the privileges required for execution of queries in the script.
run_file(IN query_script_file_name TEXT) MODIFIES SQL DATA
Input: name of text file containing QueryScript code.
Execute script from file:
mysql> call run_file('/mount/scripts/maintain.qs');