MySQL 5.7 Release Notes
As well as interactive code execution, MySQL Shell provides batch code execution from:
A file loaded for processing.
A file containing code that is redirected to the standard input for execution.
Code from a different source that is redirected to the standard input for execution.
For example:
Loading SQL code from a file for batch processing.
shell> mysqlsh --file code.jsRedirecting a file to standard input for execution.
shell> mysqlsh < code.jsRedirecting code to standard input for execution.
shell> echo "show databases;" | mysqlsh --sql --uri [email protected]:33060
Starting with version 1.0.4, on Linux you can create executable
scripts that run with MySQL Shell by including a
#! line as the first line of the script. This
line should provide the full path to MySQL Shell and include
the --file option. For example:
#!/usr/local/mysql-shell/bin/mysqlsh --file
print("Hello World\n");The script file must be marked as executable in the filesystem. Running the script invokes MySQL Shell and it executes the contents of the script.