DbForge Query Builder for MySQL
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.
What's new in this version
• Improved SQL document parser performanceView more...
• Connection through Named Pipe implemented
• Improved XML View and new JSON View for Data Editor and Viewer Window
• Additional SQL statements are supported
• .NET Framework 4.0 or higher installed
• 30-day trial
Operating system: Win NT, Win 2000, Win ME, Win XP, Win Server 2003, Win Vista, Win Vista 64 bit, Win Server 2008, Win 7, Win 7 64 bit, Win Server 2008 R2, Win 8, Win Server 2012, Win 10, Win Other
Supported languages: English
Release date: 2016-11-17
Downloads last week: 0