List:General Discussion« Previous MessageNext Message »
From:Jerry Schwartz Date:December 27 2006 3:33pm
Subject:RE: Primary field do I need one
View as plain text  
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: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
> 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/mysql?unsub=1
>
>



Thread
Primary field do I need onemeridklt26 Dec
  • Re: Primary field do I need oneMartijn Tonies26 Dec
  • Re: Primary field do I need onemeridklt26 Dec
  • RE: Primary field do I need oneJerry Schwartz27 Dec
RE: Primary field do I need oneJay Blanchard26 Dec