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: http:/

RE: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread Steve Bradwell
there's no dba 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 bu

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

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 t

RE: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread SP
lto:[EMAIL 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 m

RE: [PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread SP
May 2, 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

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 auto

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 off

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 i

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

[PHP] PRIMARY KEY vs. INDEX

2002-05-02 Thread Christoph Starkmann
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 automatically indexed? And is a unique field indexed automatically ?(I don'