dbForge Query Builder for MySQL is a new solution for creating queries and data management. It allows you to effortlessly create any complex queries, which you could not create before.
The main component of Query Builder is a visual diagram where you can "draw" your query. Adding tables, creating joins, or editing conditions will be as simple as several slicks of the brush, in your case you will do this with several clicks of the mouse. You won't be confused how to analyze and process received data the best way, using Query Builder.
Here are some key features of "dbForge Query Builder for MySQL":
· Visual query creation
· State-of-art diagram with zooming
· Query schema window for complex queries
· Undo/Redo support
· Visual editing of sub-queries
· Convenient expression builder
· Code templates with a browser window
· SQL editor with syntax coloring, bookmarks, and text search
· Extended SQL formatting in the editor
· Automatic SQL syntax check
· Advanced management of query results
· Diagram and data printing
· Customizable data export to CSV, HTML, DBF, Access, Excel and other formats
· Data editor with filtering, grouping, and sorting options
· One-click help system
· Customizable and intuitive GUI
Requirements:
· .NET Framework 2.0 or higher
Limitations:
· 30-day trial
· Nag screen
What's New in This Release: [ read full changelog ]
· InvalidCastException on paste data into the Data editor is fixed
· ArgumentOutOfRangeException on searching in Data Editor is fixed
· Bad performance on server side sorting in Data Editor is fixed
· NullReferenceException on switching to the Data document view in the SQL document is fixed
· ArgumentException on editing of several records in Data Editor is fixed
· The problem with windows layout on x64 operating systems is fixed
· ObjectDisposedException on executing a script in a SQL document is fixed
· UriFormatException on saving an SQL file on a mapped network drive is fixed
· NullReferenceException on showing data in Data Editor is fixed
· InvalidCastException on pasting LONGBLOB data in Data Editor is fixed
· InvalidOperationException on deleting a record in Data Editor is fixed
· The problem with changing database for a document is fixed
· The problem with showing the Product Update dialog behind of the main form is fixed
· The problem with connecting to MySQL server using SSL ...