Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2006

    Unanswered: Building Tables in the Administrator Question

    OK... I'm confessing upfront that I know NOTHING about mySQL. NOTHING. I've worked in MS Access for 10 years - I've used the Enterprise manager to build and manage tables. But mySQL is entirely new and to complicate matters - for the most part I don't write code.

    So.... now for my question. I've downloaded

    MySQL Server 5.0
    MySQL Administrator
    MySQL Query Browser
    MySQL Migration Toolkit

    I've figured out that in the Administrator tables are built under "Catalogs" and I've actually built a test CustomerTbl. I want the primary key to Auto Increment - name of the Primary Key field is CustomerID. I set the Auto Increment property to true - still when I enter a record, the field does not auto increment. Does anyone have any ideas what I am doing wrong?
    Attached Thumbnails Attached Thumbnails TablePic.jpg  
    If it's about mySQL - don't ask - because I don't know.

    If it's about MS Access - ask away - I've had 10 years experience.

Posting Permissions

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