MySQL Query Browser
MySQL Query Browser is the easiest visual tool for creating, executing, and optimizing SQL queries for your MySQL Database Server. The MySQL Query Browser gives you a complete set of drag-and-drop tools to visually build, analyze and manage your queries. Plus, the integrated environment provides:
- Query Toolbar to easily create and execute queries and navigate query history
- Script Editor giving you control to manually create or edit SQL statements
- Results Window so you can also easily compare and work with multiple queries
- Object Browser enabling you to manage your databases, bookmarks, and history using a Web Browser like interface
- Database Explorer where you can select tables and fields to query, as well as create and delete tables
- Table Editor allows you easily create, modify and delete tables
- Inline Help giving you instant help access to selected objects, parameters, and functions
Intuitive Easy to Use Interface
MySQL Query Browser provides an easy to use Web-browser like interface that gives you instant access to all of the Query Browser's functionality. The main query window is fully customizable allowing you to view or hide individual toolbars. Furthermore, navigation buttons allow you to browse through your query history so that you can review and re-execute a previous query.
Visual Tools to Rapidly Build Queries
The MySQL Query Browser gives you complete flexibility to build your queries. You can use the visual tools or you can maintain complete control by hand coding your query. Build a query visually by selecting tables and columns from the Database Browser that you wish to include in your query. Code for all queries and statements are displayed in the Query Area which can be easily edited or modified. Also, when establishing a master-detail pair of queries, the data in the master query is available as parameters to the detail query.
Easily Manage Multiple Queries using the Results Window
Compare multiple queries by viewing them on individual tabs or by splitting them either vertically or horizontally in the Results Window. Queries in different parts of a split result area can be joined together for master-detail analysis. Also, an Explain button can be used to get the EXPLAIN output for the current query. A Compare button allows you to quickly compare the results of two queries enabling you to determine where rows have been inserted, updated, or deleted.
Manage Databases Using the Object Browser
The Object Browser allows you to manage your databases, query bookmarks, and query history. Using the Object Browser you can:
- Choose which database and tables to query
- Add commonly-used queries to a collection of bookmarks
- Browse through previously issued queries to use them again
Place more commonly used queries in bookmarks so that you can quickly retrieve them and re-use them later by simply dragging it from the query area into the bookmark browser.
Using the database explorer you have a file explorer type of interface so you can select tables and fields to query, choose a table to edit, create new tables and databases, and drop tables and databases. Furthermore, you can filter the databases to be shown by using the search bar and simple SELECT SQL statements are automatically generated by double-clicking on a table.
Visually Create and Modify Tables
The MySQL Table Editor allows you to visually create and modify tables and the table's column and index information, as well as create FOREIGN KEY relationships. You can also specify the storage engine to be used by the table and the table's default character set.
Easily Create, Edit, and Debug SQL Statements
The Script Editor provides a robust interface for creating, editing, and debugging large SQL scripts that involve multiple SQL statements. The Script Area features line numbering and syntax highlighting making it easier to work with scripts. Plus, the Script Debugging Buttons enable you to set breakpoints and control the execution of the statements and scripts.