run_file
NAME
run_file(): Executes a QueryScript from file.TYPE
ProcedureDESCRIPTION
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.
SYNOPSIS
run_file(IN query_script_file_name TEXT) MODIFIES SQL DATA
Input: name of text file containing QueryScript code.
EXAMPLES
Execute script from file:
mysql> call run_file('/mount/scripts/maintain.qs');