EMS SQL Query for MySQL 3.2

1. User-friendly graphical interface
2. Latest MySQL versions support: compatibility with all MySQL versions from 3.23 to 6.x
3. Support of UTF8 data
4. Asynchronous query execution
5. Connect through SSH tunnel: establish connection to an intermediate SSH server and forward all MySQL commands through the secure tunnel
6. Connect through HTTP tunnel in case of Internet access through HTTP proxy only, or if the server does not allow direct connections to MySQL
7. Using drag-and-drop operations when selecting tables and fields for a query visually
8. Working simultaneously with several queries in separate windows
9. Registering selected databases to work with
10. Multiple database connections
11. Navigation within recently used queries and selecting the required queries
12. Syntax highlight, "quick code" and keyboard templates for faster editing query text
13. Tools for data grouping and filtering
14. The ability to create queries with unions and subqueries visually
15. The ability to create diagrams based on queries
16. Capabilities for viewing query plans
17. Powerful BLOB viewer/editor with several types of viewing BLOB data
18. Flexible personalization of graphical user interface
19. Multi-language GUI support

Enhancements:

• Unicode data support is implemented (InterBase/Firebird, DB2).
• The Favourites tab is added to ensure fast access to Favorite Queries.
• The Optimize Goal option is added (Oracle).
• The utility now requests re-connection when the connection to a database is lost (InterBase).
• Added the “Show default schema” option which allows you to avoid specifying objects names when it is not necessary (SQL Server, Oracle, PostgreSQL, DB2).
•  Visual building of the FROM statement subqueries is now possible.
• User-defined aggregate functions are now available in the Aggregate drop-down list in Query Builder (PostgreSQL, SQL Server).
• Some other small bugfixes and improvements.

Requirements:

•  300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
•  Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
•  64 MB of RAM or more; 128 MB or more recommended
•  20MB of available HD space for program installation
•  Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
•  Microsoft Mouse or compatible pointing device
•  Possibility to connect to any local or remote MySQL server