Toad for MySQL:

-	Overview
-	Product Features
-	Requirements

Downloads:

-	Download Freeware

Resources:

-	Toad Yahoo! Group

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?

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	Displays the Code Snippet.