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:
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
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
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
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
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
, 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
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
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
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
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
11 matches
Mail list logo