Showing entries 1 to 5
Displaying posts with tag: dbForge (reset)
Absolute Trophy Champion—dbForge Studio for MySQL Got Nine Awards

The festive season has come to an end, but Devart is still receiving presents. We have great news that we would like to share. dbForge Studio for MySQL gained nine awards from G2. The collection of dbForge Studio for MySQL counts nine new badges: According to G2 users reviews, dbForge Studio for MySQL attracts by […]

The post Absolute Trophy Champion—dbForge Studio for MySQL Got Nine Awards appeared first on Devart Blog.

InnoDB vs MyISAM: A Detailed Comparison of Two MySQL Storage Engines

If you are looking to improve the performance of MySQL databases in your software, you may need to know all the differences between InnoDB and MyISAM, two well-known types of MySQL storage engines. And if you are about to choose one of them, we believe you would like to find out what each of them […]

The post InnoDB vs MyISAM: A Detailed Comparison of Two MySQL Storage Engines appeared first on Devart Blog.

Topping the Charts Again: dbForge Studios Awarded G2 High Performer & Leader Fall 2021

More good news coming our way! It is inspiring to see that all the hard work we put into our products pays off as happy users and good reviews bring us more and more recognition on independent software reviewing platforms and marketplaces. Today, the products in question are dbForge Studios for MySQL and Oracle, which […]

The post Topping the Charts Again: dbForge Studios Awarded G2 High Performer & Leader Fall 2021 appeared first on Devart Blog.

New Connectivity Options in dbForge Fusion for MySQL, v6.6

We are glad to inform our MySQL users, that a new version of our Visual Studio plugin for MySQL database development, dbForge Fusion for MySQL, v.6.6, has been just rolled out. Connectivity The new version features a massive update of connectivity options implemented to ensure that you can easily connect and work with the latest […]

The post New Connectivity Options in dbForge Fusion for MySQL, v6.6 appeared first on Devart Blog.

Generating Identifiers – from AUTO_INCREMENT to Sequence

There are a number of options for generating ID values for your tables. In this post, Alexey Mikotkin of Devart explores your choices for generating identifiers with a look at auto_increment, triggers, UUID and sequences.

AUTO_INCREMENT

Frequently, we happen to need to fill tables with unique identifiers. Naturally, the first example of such identifiers is PRIMARY KEY data. These are usually integer values hidden from the user since their specific values are unimportant.

When adding a row to a table, you need to take this new key value from somewhere. You can set up your own process of generating a new identifier, but MySQL comes to the aid of the user with the AUTO_INCREMENT column setting. It is set as a column attribute and allows you to generate unique integer identifiers. As an example, consider the …

[Read more]
Showing entries 1 to 5