
November 12th, 2012, 12:58 PM
|
|
Contributing User
|
|
Join Date: Nov 2004
Posts: 72
Time spent in forums: 2 Days 2 h 58 m 9 sec
Reputation Power: 9
|
|
|
Primary key auto increment
I have a table called 'users' where there is a 'USRID' column that has been set as the primary key and is alphanumeric. We're working on another project and also need to have an auto increment numeric value unique to each record. I'm using navicat and when i try to add in the auto increment field and make a second key, each value of that field is 1, it doesn't increment. Any thoughts on how I could accomplish this?
thanks
|