Re: [PHP] MySQL and indexes

2002-03-18 Thread Erik Price
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

Re: [PHP] MySQL and indexes

2002-03-18 Thread John S. Huggins
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

RE: [PHP] MySQL and indexes

2002-03-18 Thread Brian Drexler
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

[PHP] MySQL and indexes

2002-03-18 Thread Jennifer Downey
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