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?
"more than one auto_increment" Not possible it seems
Thanks for helping focus my thoughts. A quick search on google for "more than one auto_increment" indicates that its not possible to have more than one auto on a table.