Building SQL queries has never been simpler, with the use of dbForge Query Builder for MySQL
. Queries are built visually, allowing you to create complex queries without writing any code. Supported database servers are MySQL, MariaDB and Percona.
Queries can be created by dropping tables on the query builder canvas. Each table is shown with its columns, which can be selected and thus included in the query. Tables can be connected between each other using visual arrows. A support for subqueries is also added, which are built in separate windows, and there is also support for building INSERT, DELETE and UPDATE SQL statements.
Queries can be executed from within the app, where you can also view results data. Results data can be grouped, sorted and filtered, and you can also print or export it. If tables are connected with other tables via foreign keys, you can look-up those tables directly from the results pane. You can do so by clicking on the foreign key column, and connected table will be shown in a new window. A results searching functionality is also added, with the support also for full-text searching.
A text query editor is included, offering advanced query building functionalities, like word completion that responds to context of query, query coloring, syntax checking, syntax formatting and showing objects information.
Data can be exported to a number of popular formats, including HTML, Excel, XML, CSV and others. You can export data from multiple tables. Export can be customized and you can also choose between different templates for a nicer looking data presentation.
In conclusion, a professional tool for building queries visually
, which can save you a lot of time and effort. It comes with a tabbed interface, with support for skins and other various customizations. Tabs can also be restored from previous sessions, enabling you to continue your work from where you left off, after the program has been closed and reopened.