Changing PRIMARY KEY
Posted: Sat Sep 08, 2007 9:30 am
My Indexes section in phpMyAdmin for my table looks like this:
How do I remove the control_number from that?
I want the control_number field to be my FOREIGN KEY, I do not know how I ended up doing this.
Code: Select all
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 7 id
control_numberI want the control_number field to be my FOREIGN KEY, I do not know how I ended up doing this.