Results 1 to 4 of 4
Apr 23, 2005, 07:59 #1
- Join Date
- Jul 2002
- 0 Post(s)
- 0 Thread(s)
Can you use mysql auto_increment on columns other than the primary key?
We have a database which is a library catalogue of hard copy documents. One of the fields is named accession_number, whcih is like a kind of offline primary key but different from the actual database primary key which is of course an auto increment. Our app needs to be able to add one onto this number in an auto_increment type of way.
I thought we might do this by using another auto_increment field. Is this possible and does anyone foresee any problems?
Last edited by jonnyporter; Apr 23, 2005 at 09:59.