Re: what is mysql complaining about ?

This is more of a mysql list question, but when tables act up on me I usually bring the DB down and ismchk -r the tables. --Joe On Fri, Dec 22, 2000 at 10:34:16AM -0800, Chris Lee wrote: > mysql> describe people; > +----------+--------------+------+-----+---------+-------+---------------------------------+ > | Field | Type | Null | Key | Default | Extra | Privileges | > +----------+--------------+------+-----+---------+-------+---------------------------------+ > | peopleID | bigint(20) | YES | | NULL | | select,insert,update,references | > | email | varchar(255) | YES | | NULL | | select,insert,update,references | > | password | varchar(255) | YES | | NULL | | select,insert,update,references | > | name | varchar(255) | YES | | NULL | | select,insert,update,references | > | city | varchar(255) | YES | | NULL | | select,insert,update,references | > +----------+--------------+------+-----+---------+-------+---------------------------------+ > 5 rows in set (0.00 sec) > > mysql> insert into people values ( '974806802083190501', > mysql> 'none@nowhere.com', 'qwe' 'Chris Lee', 'Kamloops' ); > ERROR 1136: Column count doesn't match value count at row 1 > mysql> > > MySQL has been acting very very strange on me the last few days... I > havent a clue why... > > Chris Lee > Mediawaveonline.com > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net --- Joe Stump PHP Programmer www.Care2.com