SYSTEM

SYSTEM is a command in SQL that allows you to execute a shell command from the MySQL client prompt. It is activated immediately after it is entered at the mysql> prompt and does not require a semicolon. The command is passed to your system's command interpreter and then executed. The output or result of the execution is displayed in the MySQL client.

Example

SYSTEM echo "Executing system command from MySQL";

Output

Executing system command from MySQL

Explanation

The SYSTEM command in SQL is used to execute a command from the operating system directly from the SQL prompt. In this example, the echo command is used to print a string to the console. The output is the result of the echo command, “Executing system command from MySQL”.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.