EMS SQL Query for MySQL

What is EMS SQL Query for MySQL?

EMS SQL Query for MySQL is a useful tool that allows you to quickly and easily create SQL queries to MySQL databases. Visual queries creation for MySQL, as well as direct editing of query text, is accessible.

The user-friendly graphical interface allows you to connect to MySQL databases, select tables and fields for a query to the MySQL server, define selection criteria, and more. Using this query utility, you can work with multiple MySQL queries at the same time, edit query text in the powerful SQL editor, view execution results in different modes, create MySQL queries with unions and subqueries visually, create queries-based diagrams, view MySQL queries execution plans, and perform any other operations you may need in your work with queries to the MySQL database.

Core features

• Friendly graphical interface.
• Support for the latest versions of MySQL.
• UTF8 media.
• Asynchronous query execution.
• Connect through the SSH tunnel: Connect to an intermediate SSH server and route all MySQL commands through the secure tunnel.
• Connect through the HTTP tunnel in case of Internet access only through the HTTP proxy or if the server does not allow direct connections to MySQL.
• Using drag-and-drop operations when visually selecting tables and fields for a query.
• Working simultaneously with multiple queries in separate windows.
• Registering selected databases to work.
• Multiple connections to the database.
• Navigation in recently used queries and selection of required queries.
• Syntax highlight, "fast code" and keyboard templates for faster editing of query text.
• Tools for grouping and filtering data.
• The ability to create queries with joints and subqueries visually.
• The ability to create diagrams based on queries.
• Resources for viewing query plans.
• Powerful BLOB viewer/editor with various types of BLOB data visualization.
• Flexible customization of the graphical user interface.
• Multilingual GUI support.

System requirements

300 MHz processor; Recommended 600 MHz (MHz) processor

Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows 2008 Server, Microsoft Windows Vista, Microsoft Windows 7.

64 MB of RAM or more; 128 MB or more recommended

20 MB of available HD space for program installation

Super VGA (800x600) or higher resolution video adapter and monitor; Super VGA (1024x768) or higher resolution video adapter and monitor is recommended

Microsoft mouse or compatible pointing device

Possibility to connect to any local or remote MySQL server