MySQL Query Browser
End users of web resources, as a rule, are deprived of the joy of direct communication with the MySQL database. But developers have it – more than enough. And here the key role is played by the tool for working with the database. You can, of course, use the console client, but in most cases its functionality is not enough. You can use web interfaces, such as phpMyAdmin, but working through the browser imposes certain restrictions on interactivity.
And you can take MySQL Query Browser – a utility from MySQL developers, specifically designed to bring maximum convenience to work with databases.
MySQL Query Browser is a graphical user interface *, which is designed for comfortable and convenient work directly with MySQL * DBMS database tables. It is written as a standalone application and does not require any additional components for installation and operation. Below we review the main features of this program.
The utility is equipped with a connection manager – you can enter there as many accounts as you like from different servers, having a separate set of settings and connection parameters for each. In addition to MySQL itself, MySQL Query Browser also allows the user to work with Oracle and any other database that supports ODBC.
Work with queries
Using the utility described in this article, you can very easily create SQL queries of any complexity and then execute them. At your disposal is a tree with the structure of databases on the server. If you expand the base – inside it will be a table, and inside the table – the field. The drag-and-drop technology is supported – you can drag tables and fields directly from the viewing window, indicating where this field will be added: whether to the list of those that should be selected, or to the list of conditions or sorting. MySQL Query Browser saves query history with indication of their age. For the most popular selections, you can create bookmarks.
MySQL Query Browser
When you receive the result of the request, you are ready to edit it. By allowing the table to be modified (it is disabled by default), you can make changes, edit fields, add or delete entries from the table right in the window with the result of the selection — all changes are indicated by highlighting. Then they are applied by pressing a single button. Multi-window interface allows you to work immediately with the results of several queries. Moreover, one large window can be divided into several smaller ones, thereby having the opportunity to simultaneously view a large sample in several places.
One of the key features of MySQL Query Browser is the ability to view tables in Master-Detail mode. In this case, you have one window divided into several parts. In one you make the main sample – Master. Then in the other one you make the second selection — Detail, in which you refer to the key from the first, but instead of its value, substitute the desired variable parameter. And, moving on the result of the first sample, you see the detail of the result in the second window. For example, Master – the list of articles for the last month, Detail – details about the author who wrote this article. In practice, this is extremely convenient.
Another functional feature of MySQL Query Browser is the ability to make two samples and compare them with each other. The utility will show you the different entries, highlighting them for greater clarity.
Working with scripts
Using MySQL Query Browser, it is very easy to work with SQL scripts. Built-in editor provides a convenient interface for creating, editing and subsequent execution (including step-by-step), watching the result. The editor, like the main request field, is provided with syntax highlighting.
MySQL Query Browser has a built-in regular expression utility. It allows, first, to pick up an expression and test it using different lines as an example, and second, to generate a script to load information into a database table by simply parsing the input text file.
Work with tables
The mechanism of creating, deleting, editing and modifying tables is very conveniently implemented – even a novice user can easily figure it out. In addition, the utility allows you to receive dumps of the contents of tables and their structure in the syntax of SQL. This is very convenient when you need to transfer a rough local version of the system to a remote server. Also, the result of any query can be exported in several formats, including HTML, XML, Microsoft Excel. What is not ready utility for generating a variety of reports, which in most cases are normal samples?