MySQL Tools

In the new version we made a lot of improvements and added a whole pack of new features in almost all dbForge Studio’s GUI tools. And the most remarkable thing about this release is that nearly all novelties were suggested by our users. So we hope they will enjoy working with the new version and feel that they have contributed a lot to make it as it is.

Cutting-Edge MySQL GUI Client: dbForge Studio for MySQL

With the help of our users we could work on the product on the new level, and as a result of such successful tight cooperation its standard of quality grew. This new standard includes taking into account actual needs of people using our product and implementing their exact requirements except studying the market in general and implementing features that are theoretically demanded.

When you open the application to get acquainted with the new version, you will be surely stunned and pleasantly surprised by its new look. When you start using it, we hope you will be thrilled by the inner improvements and make the best use of them:
(more…)

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

MySQL has advanced database access system. A database user can have access to the whole database, separate tables, or to separate columns of tables. Also there is a restriction for actions a user may perform with records. MySQL server uses several tables in a special database to organize such a complicated database access structure. The access policy is based on the values available in these tables.

The database that MySQL server uses to store internal data about users is called mysql by default. There are tables for storing information about users’ accounts in this database:
(more…)

Go to devart.uservoice.com and share your ideas about new features you want to see in dbForge Studio for MySQL. Here you can do the following:

• Vote for features that are already in our roadmap, and they will get higher priority in our plans
• Suggest your own features, and if they get enough votes, we will include them to the roadmap.

Your opinion helps us to make our MySQL GUI Client better and more useful for you.

We have already started implementing the following features:

(more…)

Changes (as compared to 4.50.308) include:
Bug fixes:
* Removed spaces in the integer and float format in Data Export wizard (T23612)
* Fixed NullReferenceException on saving a database project with opened table editors (T23519)
* Fixed NullReferenceException on deleting a table from a database with an opened inactive editor (T56081)
* Fixed NullReferenceException on auto hiding a tool window (T56033)
* Added possibility to edit a definer for triggers in the trigger editor (T23357)
* Fixed problem with BINARY(16) column type on selecting its data to the Data Editor (T23292)
* Fixed problem with empty gray windows after editing a table in the modal editor from Database Designer (T23164, T23018)
* Fixed link on the first page in the product tour (55629)
* Fixed syntax checking for some constructions in CREATE TABLE statements (55161)
* Fixed lost connection on the data comparing (T22521)
* Impossibility to disable Code Completion in the Express edition was fixed (54932)
* Files in database projects are saved with a relative path now (54378)

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

Often we make some sketches of the database we plan to create on a blackboard or a sheet of paper before we actually design its structure on computer. After that we discuss the entities we’ve got, normalize them and repeat these actions several times. As a result we get a completely approved database structure in the form of an image file in the project documentation.

Question:
How to create a database diagram basing on the image available?

(more…)

Devart made it to the final of 2010 DevProConnections Community Choice Awards. The awards recognize the best products and services in the industry by a community vote.

Devart has been nominated in 4 categories of 2010 DevProConnections Community Choice Awards!
Nominated products:

• Best Add-In Product – Entity Developer (page 1, category 1: Add-In)
• Best Component Set – dotConnect for Oracle (page1, category 7: Component Set)
• Best IDE Product – dbForge Studio for MySQL (page 2, category 14: IDE)
• Best Free Tool – CodeCompare (page2, category 26: Free Tool )

If some of your favorite products are in that list, please visit: http://www.surveymonkey.com/s/DEVCommChoiceFinalVoting and cast your vote for your favorite Devart products.

Note: Voting ends on September 21, 2010.

Thank you and best wishes,
The Devart Team
www.devart.com

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

In one of our posts, in the Be Careful While Using UNSIGNED Data Type in the Routine Body one, we’ve explained how to get invalid data in routine body when using UNSIGNED data type and that in this case MySQL does not throw any exceptions.

One of the possible solutions of this problem is explicit setting of the NO_UNSIGNED_SUBTRACTION mode as it is shown in an example in the MySQL documentation.

Let’s modify a routine script:

(more…)