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…

Continue reading →

Honest spam
Everyone knows that recently the Internet has become used, on the one hand, much simpler and more convenient - a lot of different services have appeared, the interfaces of sites…

Continue reading →

From birch bark to hosting: How information storage has evolved with the development of humanity
Since ancient times, people have tried to keep information known to them - both for themselves and for posterity. At first, the methods of preserving information were the most primitive,…

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?

Manage tabs "fire fox"
If you often search for information you need on the Web, sooner or later you will have to use some mechanism that simplifies working with open browser windows. Most modern…


10 effective ways to "squeeze" the maximum out of your Wi-Fi router
What could be worse in the daily life of a person of the 21st century than a slow Internet? The fall in Internet speed leads to the destruction of nerve…


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…


Svg as foreboding
Generally speaking, the hype around Scalable Vector Graphics (SVG) began almost immediately after the W3C assembled the SVG Working Group, led by Chris Lilley, and announced the standard. This happened…