MySQL Console allows you to use a command-line interface. In other words, it provides interactive text-based screen for you to query input and result output from database.

Just sample open the console and use the toolbar below, allowing you to run, save and load your SQL statements.

Open Console

To open a console window

• Open the connection and select Tools -> Console... from the main menu or just simply press F6.
• Edit your SQL statement in the console.

Hint: To create new console you can also right-click the Database node of the navigation pane and select the Console... from the popup menu.

To open a console window with loading from a text file

• Open the connection and select Tools -> Console... from the main menu or just simply press F6.
• Click Load.

Hint: You are allowed to open multiple console windows which each represents different connection.

Save Statements

To save the SQL statement into text file

• Open the connection and select Tools -> Console... from the main menu or just simply press F6.
• Edit your SQL statement in the console.
• Click Save.

Stop Executing

To stop running the SQL statement

• Click Stop.

Erase Content

To clear all SQL statements in console window

• Click Clear.

Exit Console

To exit a console window

• Click the cross button at the main bar.
  or
• Type the quit in the console window