On Monday, March 18, 2002, at 03:40 PM, Jennifer Downey wrote:
> Just wondering, does a table have to have an index? If so what should I
> consider when making a colum an index?
You're not required to have an index, as far as I know. It's just that
an index is a way of optimizing retrievals
I have seen this problem before and, yes, an index field with
autoincrement is always a good thing to have.
Perhaps, this is not necessary, but usually works.
John
On Mon, 18 Mar 2002, Jennifer Downey wrote:
>-Hi all,
>-
>-Just wondering, does a table have to have an index? If so what should I
riginal Message-
From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 3:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL and indexes
Hi all,
Just wondering, does a table have to have an index? If so what should I
consider when making a colum an index?
Here is
Hi all,
Just wondering, does a table have to have an index? If so what should I
consider when making a colum an index?
Here is the table I am using but I can't get php to update it.
Is it because there is no index?
CREATE TABLE wt_pet (
petid varchar(100) default NULL,
pet_user int(10) NOT
4 matches
Mail list logo