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
>-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
>-
>-
>-
>---
>-PHP General Mailing List (http://www.php.net/)
>-To unsubscribe, visit: http://www.php.net/unsub.php
>-
**************************************
John Huggins
VANet
[EMAIL PROTECTED]
http://www.va.net/
**************************************
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
