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 →

Telegram lock and deadline for memes: 5 of the loudest scandals of the IT industry lately
Last year was rich in various scandals in the world of information technology. What is it worth blocking Telegram Roskomnadzor messenger or data leakage of 87 million Facebook social network…

Continue reading →

7 "hard" examples of how in different countries they are trying to control the functioning of the Internet
Recently, politicians, businessmen and even “media” personalities are talking more and more about various aspects of the Internet and, increasingly, the words about it sound in a positive way. The…

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?

How to study SEO
If you go to any forum, one way or another in contact with the SEO theme, and ask a question like “how to learn SEO?”, Then in 90% of cases…


One site & nb p; & mda h; two servers?
In most cases, the placement of the site is as follows. All information is hosted on the server. In the future, requests from the user's computer using the DNS system…


Spammers began to unite in online clubs
Spammers also know the parable of the broom twigs, which are easy to break individually, but together it is almost impossible. And these bad people, which most normal people hate…


The first beta version of Firefox 3
The main event of the past week, apparently, should be considered the release of the first beta version of the Mozilla Firefox 3 browser. Among the innovations, developers note additional…