Site Owners Forums - Webmaster Forums - View Single Post - Why can't I have multiple auto_increment columns in the same table?

eigeehte · 12-12-2011, 08:06 PM

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?

12-12-2011, 08:06 PM	#1
eigeehte Registered User Join Date: Nov 2011 Posts: 29	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?