MySQL and indexes
| From: | Jennifer Downey | Date: | Mon, 18 Mar 2002 20:40:56 +0000 |
| Subject: | MySQL and indexes | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-89008@lists.php.net to get a copy of this message | ||
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 NULL default '0',
petname varchar(50) NOT NULL default '',
pet_sex enum('Male','Female') NOT NULL default 'Male',
pet_equip varchar(50) NOT NULL default '',
pet_state varchar(20) NOT NULL default '',
pet_hunger varchar(20) NOT NULL default '',
pet_date date NOT NULL default '0000-00-00',
num_pets int(1) NOT NULL default '0',
) TYPE=MyISAM;
Thanks
Jennifer Downey