SHUTDOWN
Example
Section titled “Example”SHUTDOWNOutput
Section titled “Output”Server shutdown in progress...Explanation
Section titled “Explanation”In the presented example, SHUTDOWN is a MySQL statement used to safely stop the MySQL server. The “Server shutdown in progress…” notification indicates that the server is executing the command.
Example
Section titled “Example”SHUTDOWN;Output
Section titled “Output”SQL Server is shutting down.Explanation
Section titled “Explanation”The SHUTDOWN command is used to safely stop the SQL Server. Upon executing this command, SQL Server ceases processing after completing all active processes and transactions.
Example
Section titled “Example”SHUTDOWN IMMEDIATE;Output
Section titled “Output”No output will be returned for the SHUTDOWN IMMEDIATE command. The database is immediately shut down after the command is issued.
Explanation
Section titled “Explanation”The SHUTDOWN IMMEDIATE command is used in Oracle SQL to shut down a currently running Oracle database instance. It disallows new connections and disconnects existing sessions. As it’s an administrative command, the output is neither visible nor retrievable.