WampServer

Hi There - When I add a new record to a database running in PHP/MyAdmin SQL, the record does not automatically add a Primary Key / Unique ID. I need this as I am going to want to link tables. Any ideas? Thanks so much. -Beth

beth these are set on the structure page of the table


select your table> press the structure icon.


on the right of each field is about 5 buttons


unique, primary, auto , null etc

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

So if I want to make sure that there is a number associated with the record, which do I add to the structure?
Primary
Unique
Index

??? Or do I go into the field and select AUTO_INCREMENT or make it so the record is not NULL????

Thanks so much. Beth



Edited 1 time(s). Last edit at 07/26/2011 05:08PM by bethabernathy.