The MySQL Query Browser makes it easy to query your MySQL database.

24 May, 2007 (15:06) | MySQL | By: clive

MySQL Query Browser

MySQL Query Browser is a visual tool for creating, executing, and optimizing SQL queries for your MySQL Database Server. It gives you a complete set of drag-and-drop tools to visually build, analyze and manage your queries. It also provides:

Query Toolbar to create and execute queries and navigate query history

Script Editor gives you control to manually create or edit SQL statements

Results Window so you can compare and work with multiple queries

Object Browser enables you to manage your databases, bookmarks, and history using a Web Browser like interface

Database Explorer enables you to select tables and fields to query, as well as create and delete tables

Table Editor allows you to create, modify and delete tables

Inline Help gives you instant help access to selected objects, parameters, and functions

Intuitive Easy to Use Interface

MySQL Query Browser provides a Web-browser like interface giving you instant access to all of the Query Browser’s functionality. The main query window is customizable and allows you to view or hide individual toolbars. 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 allows you to build your own queries. You can use the visual tools or you can code your own query.

Easily Manage Multiple Queries using the Results Window

You can 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.

Manage Databases Using the Object Browser

The Object Browser allows you to manage your databases, query bookmarks, and query history.

You can use the Object Browser to:

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

The database explorer is a file explorer type interface allowing you to select tables and fields to query, choose a table to edit, create new tables and databases, and drop tables and databases.

Visually Create and Modify Tables

The MySQL Table Editor allows you to visually create and modify tables as well as table’s column and index information. You can also create FOREIGN KEY relationships and specify the storage engine and the table’s default character set.

Easily Create, Edit, and Debug SQL Statements

The Script Editor is an interface for creating, editing, and debugging large SQL scripts involving multiple SQL statements. The Script Area features line numbering and syntax highlighting making it easier to work with scripts.