Toad for MySQL:

-	Overview
-	Product Features
-	Requirements

Downloads:

-	Download Freeware

Resources:

-	Toad Yahoo! Group
-	Quest MySQL Pipeline

Frequently Asked Questions

What is Toad
Why does Toad use Microsoft .NET?
Where are settings saved?
How do I assign shortcut keys?
What are the shortcut keys?
Why do I get an error when launching the Editor?
Why do my Toad-generated DDL scripts fail to execute?

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.
<auto-replace token>+SPACE	Automatically replaces a misspelled word, inserts symbols, and expands text.
CTRL+SPACE	Displays the Code Snippets folder browser.
<code snippet shortcut name>+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