8 things that in no case can not be done on the Internet, so as not to lose personal data
With the spread of the Internet, the era of accessible content, fast exchange of information and rapid communication at any distance began. However, along with all this came the problems,…

Continue reading →

"Half a Century in Space - The Epoch of Search"
On the eve of the atrium of the Novinsky Passage shopping center, Google held an exhibition “Half a Century in Space - Search Epoch”, timed to coincide with the 50th…

Continue reading →

What features does a consumer loan online have?
The Internet is an environment of great opportunities for people. It allows you to pass the time for an interesting, colorful game or watching a film of the most different…

Continue reading →

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?

VPS & nb; & mda h; what it is
Solutions for sharing computer resources into mutually independent virtual machines were developed more than forty years ago, back in the era of mainframes. IBM has developed a special operating system…


Electronic money as a means of payment on the Internet
At the moment, more and more services are provided on the Internet, and very often you need to pay for an interesting program, some kind of service or product. In…


Twilight CMS
The Content Manager System (CMS) site creation software class was created to facilitate the work of webmasters. These programs are distributed in different ways. As a rule, via the Internet,…


Fathers and Sons of the Digital Millennium: Another Brick in the Wall
The emergence of the Internet not only connected nations and continents in a globalized rush, but also inserted its small brick into the eternal wall separating fathers and children, as…