Toad for MySQL Tips & Tricks

Sabari · #41 (**permalink**) 12-18-2007, 02:43 AM

You can use the Search field in the Options dialog to find any term, option, or value if you forget which panel they are in.

Sabari · #42 (**permalink**) 12-18-2007, 02:44 AM

You can quickly navigate to frequently used objects using the Object History toolbar buttons in the Database Browser.

Sabari · #43 (**permalink**) 12-19-2007, 05:45 AM

You can send a SQL script from the Script tab in the Database Browser to the Editor

Sabari · #44 (**permalink**) 12-19-2007, 05:45 AM

You can double click a statement from the SQL Recall list to automatically add it to the Editor

Sabari · #45 (**permalink**) 12-19-2007, 05:46 AM

The Object Palette gives you the functionality of the Database Browser for the current connection in a convenient tool window.

Sabari · #46 (**permalink**) 12-19-2007, 05:46 AM

You can use groups to organize your connections; and can use the "execute groups" feature to execute a script in the Editor against any or all connections in the selected group.

Sabari · #47 (**permalink**) 12-19-2007, 05:47 AM

You can select from a list of databases, tables, or columns when creating SQL statements by typing a period or by pressing Ctrl period.

Sabari · #48 (**permalink**) 12-19-2007, 05:47 AM

You can send a SQL script from the Script tab in the Database Browser to the Editor.

Sabari · #49 (**permalink**) 12-19-2007, 05:48 AM

When exporting data from a grid, right click and select "Read All Rows" if you want to export all rows instead of the default number of rows initially returned for the query.

Sabari · #50 (**permalink**) 12-19-2007, 05:48 AM

You can create a new group separator in the menus or toolbars while customizing. Right-click the menu or toolbar item and select "Begin a group."

Sabari · #51 (**permalink**) 12-19-2007, 05:49 AM

You can quickly navigate to frequently used objects using the Object History toolbar buttons in the Database Browser.

Sabari · #52 (**permalink**) 12-19-2007, 05:49 AM

Messages that display in the status bar are logged in the Output tool window under the category "Statusbar."

Sabari · #53 (**permalink**) 12-20-2007, 01:44 AM

If you lose the location of the cursor in an Editor, you can find it easily by pressing the Escape key, which displays a locator beacon at the cursor's location.

Sabari · #54 (**permalink**) 12-20-2007, 01:44 AM

You can create a new group separator in the menus or toolbars while customizing. Right-click the menu or toolbar item and select "Begin a group."

Sabari · #55 (**permalink**) 12-20-2007, 01:45 AM

When exporting data from a grid, right click and select "Read All Rows" if you want to export all rows instead of the default number of rows initially returned for the query

Sabari · #56 (**permalink**) 12-20-2007, 01:46 AM

You can change the connection for the current window by selecting the connection in the lower right of the status bar and choosing another open connection. Only connections compatible with the window display in the list.

Sabari · #57 (**permalink**) 12-20-2007, 01:46 AM

You can quickly navigate to frequently used objects using the Object History toolbar buttons in the Database Browser.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

LinkBacks (?) LinkBack to this Thread: http://www.discussweb.com/database-support/4696-toad-mysql-tips-tricks.html
Posted By	For	Type	Date
Discover From Your Favorite Topic or Web Page: princess and the toad	This thread	Refback	02-28-2008 07:07 PM

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
C# .Net Tips & Tricks	oxygen	C# Programming	84	12-02-2008 02:12 AM
SAP Tips & Tricks	leoraja8	Operating Systems	0	03-29-2008 01:11 AM
Upload Files to MySQL using PHP Tips & Tricks	Sabari	PHP Programming	3	12-18-2007 06:32 AM
PHP Tips and Tricks	Sabari	PHP Programming	20	12-18-2007 06:26 AM
mysql database dump tips and tricks	write2ashokkumar	Database Support	31	12-14-2007 11:54 PM