You do not absolutely need a primary key, but I suggest you add an auto-increment primary key anyways. When you start coding your PHP application, you may find that you need to identify a specific record and this auto-increment field will be your way to do that.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: meridklt [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 26, 2006 2:53 AM > To: mysql@lists.mysql.com > Subject: Primary field do I need one > > > I'm working through (my first day) PHP & MySQL for Dummies > and I'm stuck on > the primary field for my database. > I want to create a racing pigeon results database that has 6 > fields only. > The results will be imported into the database in bulk from a CSV file > Owner - GBring - Ering - Arrivedtime - date - position > > If I'm not wrong, surely whichever one of the first 3 fields > I create as a > primary field will stop me entering any races after the first > one, because > every race thereafter will always for the most part be the > same owners and > rings. > > So do I have to have a primary key? > > > -- > View this message in context: > http://www.nabble.com/Primary-field-do-I-need-one-tf2881594.ht > ml#a8051644 > Sent from the MySQL - General mailing list archive at Nabble.com. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
