[RESOLVED] Changing Primary Field

[AHoward007]

I want to change my Primary field in MySQL database. First I added a new field to serve as the Primary but when I selected Primary from the drop down menu it says Primary field already exists. Is there a way to change my original Primary to Index w/o having to delete it?

Sorry new to DB's.

Is a Primary field always required? I'm not sure I really need one so I'm just creating one with Auto increment selected so the rows are numbered.

[bradgrafelman]

Just drop the PRIMARY key on the old column before you add it to the new column.

[AHoward007]

Thanks!!! Dropped primary key from field. I tried this earlier and it didn't work. I noticed the field was also indexed as unique so I deleted that also. Now I'm able to enter duplicate data in the same field column.