Generating Identifiers – from AUTO_INCREMENT to Sequence
Percona Community
OCTOBER 12, 2018
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.
Let's personalize your content