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.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -----Original Message-----
> From: meridklt [mailto:meridklt@stripped]
> Sent: Tuesday, December 26, 2006 2:53 AM
> To: mysql@stripped
> 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
> So do I have to have a primary key?
> View this message in context:
> 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: