Why can't I have multiple auto_increment columns in the same table?
 

I know MySQL limits auto_increment columns to primary keys. My first thought is that it's a performance restriction, since there probably is some counter table somewhere that must be locked in order to get this value.

Why can't I have multiple auto_increment columns in the same table?