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.
|Describes the object next to the cursor.|
|Executes an SQL script. |
|Toggles between the Editor and Grid. |
|Executes an SQL statement.|
|Recalls the previous SQL statement.|
|Adds the selected statement to named SQL Recall.|
|Comments the selected line.|
|CTRL SHIFT MINUS|
|Uncomments the selected line.|
|Indents the selected line.|
|Outdents the selected line.|
|CTRL SHIFT 09|
|Sets a numbered bookmark at the selected line.|
|Go to the numbered bookmark.|
|Sets a position indicator at the cursor location|
|Pops the position indicator.|
|CTRL SHIFT R|
|Start/Stop recording a macro.|
|CTRL SHIFT P|
|Play the recorded macro. |
|Converts the selected text to lowercase.|
|Converts the selected text to uppercase.|
|Copies the selected text to the clipboard. |
|Cuts the selected text for pasting in the clipboard. |
|Pastes text from the clipboard.|
|CTRL SHIFT V|
|Pastes items from the Clipboard Ring.|
|Moves the cursor to the beginning of the line.|
|Moves the cursor to the beginning of the file.|
|Moves the cursor to the end of the line.|
|Moves the cursor to the end of the file.|
|CTRL ] or CTRL [ |
|Moves the cursor to the matching bracket |
|Deletes the selected text (if text is selected); otherwise, deletes the previous character.|
|Deletes text to the beginning of the previous word.|
|Deletes text to the beginning of the next word.|
|CTRL SHIFT DELETE|
|Deletes the entire line.|
|Finds the next occurrence of text.|
|Finds the previous occurrence of text.|
|Go to line number.|
|Performs an incremental search.|
|CTRL SHIFT I|
|Performs a reverse incremental search. |
|Exits the incremental search mode.|
|Displays a drop-down list in the Editor so you can quickly select a database, table, or column. |
|Scrolls up the window.|
|Scrolls down the window.|
|Automatically replaces a misspelled word, inserts symbols, and expands text.|
|CTRL SPACE |
|Displays the Code Snippets folder browser.|
|Inserts the code snippet template.|
|CTRL ZERO CTRL DELETE|
|Sets the column value for the current cell to Null in the data grid.|
|Run to breakpoint|
|Run to cursor|
|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