Blog posts tagged with 'autoincrement':
Composite key autoincrements
Date: 17 Dec 2010Tags: [ autoincrement ] [ MySQL ]
Autoincrement is sometimes called a “poor-man-sequence”. Sequences in other DB systems are counters that can be used for automatically number fields when inserting data, just like autoincrement in MySQL does, but they can be much more complex. However, in MySQL you do not always you want or need increments of 1. Sometimes you need something a little more complex than that and MySQL leaves you pretty much in the cold. There is a neat little trick that can solve some “autoincrement” problems…