query builder

Changes (as compared to 4.50.339) include:
Bug fixes:
* The error on entering selection criteria after selecting Group By fields in Query Builder fixed (T26884)
* The problem with showing 0 as a parameter value instead of NULL in the parameter editor fixed (T26867)
* Removing field’s autoincrement sign on adding index in the table fixed (T24859)
* Extra new line on copying data from a cell in Data Editor removed (T27021)
* The problem with losing ON UPDATE CURRENT_TIMESTAMP during editing a table fixed (T27090)
* The problems with connecting to MySQL Server via SSH tunnel fixed (T26911, T20079)
* InvalidOperationExceptions on generating schema synchronization script in the Schema Comparison tool fixed (T27106, T27108)

Read more about the tool: http://www.devart.com/dbforge/mysql/studio/

Downloads: http://www.devart.com/dbforge/mysql/studio/download.html

To get information from a database it is necessary to execute a query to get this data.

Usually an ordinary SQL editor is used to create queries. To use such editor, one should remember the syntax of the SELECT operator and the names of tables and columns.

Let’s use a visual instrument developed specially to design queries, and see that it’s much easier to create queries visually instead of typing them in an editor.

Task:

It’s necessary to show the salaries of the employees of departments situated in different cities for the 2008 year in descending order.

(more…)

The Sakila project was designed to demonstrate all cutting-edge capabilities of dbForge Studio for MySQL such as Database Projects, Database Diagram, Data Reports, Pivot Grid, Visual Query Builder, Code Refactoring, Database Comparison and Synchronization, and also to let a user get acquainted with the mentioned functionality quickly and easily with the help of the prepared examples.

(more…)

Devart today releases dbForge Studio for MySQL, v4.50 – cutting-edge administration tool and development environment for professional working with MySQL databases.

With dbForge Studio, Devart continues its initiative to produce efficient database experiences for all the people in MySQL world.

New features in dbForge Studio for MySQL, v4.50 include:

(more…)

Devart development team is glad to present dbForge Query Builder for SQL Server, a modern and affordable tool that will bring you confidence in creating queries of any complexity. With dbForge Query Builder, Devart continues its initiative to produce efficient database experiences for all the people in SQL Server world.

dbForge Query Builder for SQL Server

Designed specifically for people who are working with databases, dbForge Query Builder blends rich functionality and a simple user interface to provide:

(more…)

Devart announced the release of dbForge Query Builder for MySQL v 1.10, a professional tool for quick creation of any queries without code and extended management of query results.

The highlights of Query Builder for MySQL v 1.10 include:

(more…)

If you often need to create and modify views in your MySQL development you will like dbForge Studio for MySQL in-place query editing feature. This feature allows integration of powerful Query Builder tool with view editor without annoying copy/paste.

(more…)