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.
As an alternative to batch execution of a file, you can also control MySQL Shell from a terminal, see Section 5.7, “API Command Line Interface”.
In batch mode, all the command logic described at
Section 5.2, “Interactive Code Execution” is not
available, only valid code for the active language can be
executed. When processing SQL code, it is executed statement by
statement using the following logic: read/process/print result.
When processing non-SQL code, it is loaded entirely from the input
source and executed as a unit. Use the
-i) command-line option to configure
MySQL Shell to process the input source as if it were being
issued in interactive mode; this enables all the features provided
by the Interactive mode to be used in batch processing.
In this case, whatever the source is, it is read line by line and processed using the interactive pipeline.
The input is processed based on the current programming language
change the default programming language using the
defaultMode MySQL Shell configuration option.
Files with the extensions
.sql are always
processed in the appropriate language mode, regardless of the
default programming language.
shell> mysqlsh --file code.js
shell> mysqlsh < code.js
This example shows how to redirect SQL code to standard input for execution:
shell> echo "show databases;" | mysqlsh --sql --uri firstname.lastname@example.org:33060
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.