Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    124

    Unanswered: primary key id help - autonumber

    I'm brand new to using MySQL. We setup a simple table with 8 fields. The primary key was not setup as an autonumber. The primary key was setup initially for the title field, which we want to setup now an id field as an autonumber.

    We when try to insert the id field as the primary key it doesn't show in the table. Can anyne offer any help or suggestions on what might be causing the id field to not show up?

    Thanks for any help.
    -Dman100-

  2. #2
    Join Date
    Mar 2004
    Posts
    480
    show us how you are attempting to alter the table to add this column.

  3. #3
    Join Date
    Jan 2004
    Posts
    124
    Problem fixed...
    Just exported to an Access db and added the id field set to the primary key and then re-exported to MySQL.
    -Dman100-

Posting Permissions

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