What is Toad?
Toad™ for MySQL is a tool that improves the productivity of developers and administrators by providing an easy-to-use MySQL development environment. With Toad, developers and database administrators can use a familiar, proven tool to manage MySQL databases.
Why does Toad use Microsoft .NET?
Microsoft's .NET technology provides the ability to quickly build, deploy, manage,
and use connected, security-enhanced solutions. Leveraging this technology, Quest
can rapidly develop scalable applications that are agile enough to meet current and
future needs.
Where are settings saved?
You can quickly navigate to the directory where settings files are saved by clicking the Application Data Directory link in the About dialog (Help | About). Settings files are saved by default in:
C:\Documents and Settings\username\Local Settings\Application Data\Quest Software\Toad for MySQL
How do I assign shortcut keys
In order to assign a shortcut key, you must first save a new keyboard scheme because the default keyboard scheme is read-only. Consider the following guidelines for assigning shortcuts:
-
You can create multiple keyboard schemes and can assign more than one shortcut to an action.
-
You cannot assign a keyboard shortcut that is permanently set as a default Windows shortcut such as F10.
-
Any shortcut you assign to an action will apply to all databases for that action.
To assign a shortcut key
-
Open the Options window (Keyboard: ALT T O) and select Environment | Keyboard.
-
Click Save As beside the Current Keyboard Scheme list.
-
Enter a name for the new scheme in the Save keyboard scheme dialog, and click OK.
-
Select the command to assign a shortcut from the list of commands.
-
Select the template where you want to assign the shortcut from the Assign for use in list.
-
Press the keyboard shortcut keys in the order you want them to be pressed in the Keyboard Shortcut field.
-
Click Assign.
What are the shortcut keys?
The following table describes the default shortcut keys in Toad.
| Editor Shortcuts |
Description |
| F4 |
Describes the object next to the cursor. |
|
F5
|
Executes an SQL script.
|
| F6 |
Toggles between the Editor and Grid. |
|
F9
|
Executes an SQL statement.
|
|
F8
|
Recalls the previous SQL statement.
|
|
CTRL N
|
Adds the selected statement to named SQL Recall.
|
|
CTRL MINUS
|
Comments the selected line.
|
|
CTRL SHIFT MINUS
|
Uncomments the selected line.
|
|
TAB
|
Indents the selected line.
|
|
SHIFT TAB
|
Outdents the selected line.
|
|
CTRL SHIFT 0–9
|
Sets a numbered bookmark at the selected line.
|
|
CTRL 0–9
|
Go to the numbered bookmark.
|
|
SHIFT ESC
|
Sets a position indicator at the cursor location
|
|
ESC
|
Pops the position indicator.
|
|
CTRL SHIFT R
|
Start/Stop recording a macro.
|
|
CTRL SHIFT P
|
Play the recorded macro.
|
|
CTRL L
|
Converts the selected text to lowercase.
|
|
CTRL U
|
Converts the selected text to uppercase.
|
|
CTRL C
|
Copies the selected text to the clipboard.
|
|
CTRL X
|
Cuts the selected text for pasting in the clipboard.
|
|
CTRL V
|
Pastes text from the clipboard.
|
|
CTRL SHIFT V
|
Pastes items from the Clipboard Ring.
|
|
HOME
|
Moves the cursor to the beginning of the line.
|
|
CTRL HOME
|
Moves the cursor to the beginning of the file.
|
|
END
|
Moves the cursor to the end of the line.
|
|
CTRL END
|
Moves the cursor to the end of the file.
|
|
CTRL ] or CTRL [
|
Moves the cursor to the matching bracket
|
|
BACKSPACE
|
Deletes the selected text (if text is selected); otherwise, deletes the previous character.
|
|
CTRL BACKSPACE
|
Deletes text to the beginning of the previous word.
|
|
CTRL DELETE
|
Deletes text to the beginning of the next word.
|
|
CTRL SHIFT DELETE
|
Deletes the entire line.
|
|
CTRL F
|
Finds text.
|
|
F3
|
Finds the next occurrence of text.
|
|
SHIFT F3
|
Finds the previous occurrence of text.
|
|
CTRL G
|
Go to line number.
|
|
CTRL I
|
Performs an incremental search.
|
|
CTRL SHIFT I
|
Performs a reverse incremental search.
|
|
ESC
|
Exits the incremental search mode.
|
|
CTRL PERIOD
|
Displays a drop-down list in the Editor so you can quickly select a database, table, or column.
|
|
CTRL UP
|
Scrolls up the window.
|
|
CTRL DOWN
|
Scrolls down the window.
|
|
SPACE
|
Automatically replaces a misspelled word, inserts symbols, and expands text.
|
|
CTRL SPACE
|
Displays the Code Snippets folder browser.
|
|
CTRL SPACE
|
Inserts the code snippet template.
|
|
CTRL ZERO
CTRL DELETE
|
Sets the column value for the current cell to Null in the data grid.
|
| Debugger Shortcuts |
Description |
|
F7
|
Step into
|
|
SHIFT F7
|
Step out
|
|
F8
|
Step over
|
|
F11
|
Run to breakpoint
|
|
F12
|
Run to cursor
|
|
CTRL B
|
Set breakpoint
|
|
CTRL W
|
Add watch at cursor
|
Why do I get an error when launching the Editor?
Attempting to launch the Editor after migrating settings from the 1.0 release may result in an error stating, "If a # is specified as the start of a web color, six hexadecimal digits must follow." This error occurs because you modified syntax highlighting for a language in the 1.0 release, and new highlighting styles were introduced in the 2.0 release. As a workaround, perform the following:
-
Select Help | About and click the Application Data Directory link in the About dialog to open the data directory.
-
Select Templates\Languages from the data directory.
-
Delete all the files in the Languages directory.
Note: Any custom highlighting styles you set in the 1.0 release will be lost. You do not need to exit or restart Toad to continue.
Why do my Toad-generated DDL scripts fail to execute?
Summary: DDL scripts for Stored Procedures, created within Toad for MySQL v2.0.1, cannot be executed by external programs such as MySQL Query Browser or MySQL Command-Line Tool. As a result, the files created by Toad for MySQL cannot be use for deployment. Click here for more info. Click here to download the patch DLL