Last month’s “Tech Support” introduced MySQL Administrator, a powerful, visual administration console that enables you to easily administer your MySQL environment and discover in great detail how your databases are operating. However, MySQL Administrator doesn’t help much with SQL queries.
To craft and run SQL, try the MySQL Query Browser, which, like MySQL Administrator, is available directly from MySQL AB under the same dual-license as MySQL itself. The MySQL Query Browser is a visual tool for creating, executing, and optimizing SQL queries. The application gives you a complete set of drag-and-drop tools to visually build, analyze, and manage your queries. It also provides a number of other powerful features: Use the Query Toolbar to easily create and execute queries and navigate query history; manually create or edit SQL statements with built-in Script Editor; use the Results Window to compare and work with multiple queries; manage your databases, bookmarks, and history using a web browser-like interface in the Object Browser; and select tables and fields to query, and create and delete tables with the Database Explorer and Table Editor.
You can obtain both MySQL Administrator and MySQL Query Browser by downloading the MySQL GUI Tools Bundle from http://dev.mysql.com/downloads/gui-tools/5.0.html. Binaries for all major platforms and source code are available, and binary installation is a snap.
Once you have the software on your system, fire it up and take a look at what it can actually do. To launch…
Please log in to view this content.
Not Yet a Member?
Register with LinuxMagazine.com and get free access to the entire archive, including:
