EMS MySQL Query is an utility for quick and simple building SQL queries to MySQL databases. Visual building as well as direct editing of a query text is available. User-friendly graphical interface allows you to connect to databases, select tables and fields for a query, set the selection criteria and many more. You can work with several queries at once, edit queries and view the execution results in several modes and perform any other operations you may need in your work with database queries.
- selecting tables and fields for a query visually by drag&drop; - possibility of working with several queries in separate windows; - registering databases for working with the required databases only; - multiple database connections; - history of recently used queries with a possibility of navigating between them and selecting the required queries; - syntax highlight, "quick code" and keyboard templates for faster editing query text; - fully customizable interface, including interface language; - and many more features...
What is MySQL Extract?
EMS MySQL Extract is a powerful and easy-to-use utility for creating database backups in form of SQL scripts. It allows you to save metadata of all database objects as well as table data. With flexible customization of the extract process you can select objects and data tables for extract and tune many other extract options. MySQL Extract includes a graphical wizard, guiding you through the extract process step by step, and a command-line service for creating backups in one-touch.
- connecting to the server and selecting databases easily; - extracting metadata either from single or multiple databases at a time; - possibility of selecting the extracted database objects; - extracting table data to SQL script as INSERT statements with possibility to select data tables; - saving/loading templates with all the extract parameters and options; - console application for extracting metadata and data using the template file; - and more...