RE: [PHP] PRIMARY KEY vs. INDEX

2002-05-03 Thread Christoph Starkmann
Yes, but that's what the php-db list is for. I am sorry... Gonna get this list. Kiko -- It's not a bug, it's a feature. christoph starkmann mailto:[EMAIL PROTECTED] http://www.gruppe-69.com/ ICQ: 100601600 -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread 1LT John W. Holmes
I guess I got a very easy question for the pros here... I've been searching the documentaion of mySQL, but didn't find the answer (even though I'm sure it's out there somewhere :))... Is a primary key in mySQL automatically indexed? And is a unique field indexed automatically ?(I don't

Re: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread Miles Thompson
Christoph, Indexes are built on key fields, so yes. When a field is identified as a key it is indexed. To answer your second question, it is the index which maintains the uniqueness of a field. A book is a really good analogy. If you wanted to look up the references to string, you can do it

Re: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread Dan Hardiker
To clarify, an indexed field is *not* inheriently unique. You can have an indexed field which is not unique, and a unique field which is not indexed (hence the options being available). A primary key is both indexed and unique (with the slight adaption of compound keys)... but this is majorly

Re: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread Jason Wong
On Thursday 02 May 2002 20:13, Christoph Starkmann wrote: Hi there! I guess I got a very easy question for the pros here... I've been searching the documentaion of mySQL, but didn't find the answer (even though I'm sure it's out there somewhere :))... Is a primary key in mySQL

RE: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread SP
, 2002 8:41 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] PRIMARY KEY vs. INDEX To clarify, an indexed field is *not* inheriently unique. You can have an indexed field which is not unique, and a unique field which is not indexed (hence the options being

RE: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread SP
PROTECTED]] Sent: May 2, 2002 1:21 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] PRIMARY KEY vs. INDEX On Thursday 02 May 2002 20:13, Christoph Starkmann wrote: Hi there! I guess I got a very easy question for the pros here... I've been searching the documentaion of mySQL, but didn't find the answer

Re: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread Jason Wong
On Friday 03 May 2002 03:17, SP wrote: Yeah this isn't specifically about php but most people use databases so I think this is relevant. I like it when we have discussions like these instead of someone posting up a bunch of code and asking to find a missing ' or }. Yes, but that's what the

RE: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread SP
True. -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]] Sent: May 2, 2002 3:26 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] PRIMARY KEY vs. INDEX On Friday 03 May 2002 03:17, SP wrote: Yeah this isn't specifically about php but most people use databases so I think

RE: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread Steve Bradwell
where I work. Thanks -Steve. -Original Message- From: SP [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 3:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] PRIMARY KEY vs. INDEX Indexes are good but the only thing you have