SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Threaded View

  1. #1
    SitePoint Member
    Join Date
    Jul 2002
    Posts
    22
    Mentioned
    0 Post(s)
    Tagged
    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?

    Cheers
    Jonathan
    Last edited by jonnyporter; Apr 23, 2005 at 09:59.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •