RE: [PHP] PRIMARY KEY vs. INDEX

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 }. -----Original Message----- From: Jason Wong [mailto:php-general@gremlins.com.hk] Sent: May 2, 2002 1:21 PM To: php-general@lists.php.net 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 (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 think and > don't hope so, but one never knows) Pardon, I'm new here, but what has this got to do with PHP? -- Jason Wong -> Gremlins Associates -> www.gremlins.com.hk Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* It's great to be smart 'cause then you know stuff. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php