Devart Blog

query builder

GUI Tool for MySQL: dbForge Studio for MySQL, v4.50.342 Released

Posted by on March 18th, 2011

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

How To: Create a Query in One Shot

Posted by on August 31st, 2010

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…)

Quick start in database development with Sakila database project

Posted by on August 12th, 2010

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…)

More Tools Available: dbForge Studio for MySQL, v4.50!

Posted by on June 21st, 2010

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…)

Enjoy Creating Complex Queries with dbForge Query Builder for SQL Server

Posted by on May 18th, 2010

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

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…)

Query Builder for MySQL v 1.10 – unlimited database connectivity and better performance

Posted by on September 9th, 2009

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…)

Designing Views With Query Builder

Posted by on May 22nd, 2009

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…)