Re: what is mysql complaining about ?

You know what? your 100% right. get this. - I create a brand new table, - put one value in it - run isamchk, and Ive got a broken table that isamch fixes. now thats wierd. I wonder if my MySQL is busted. It still doesnt fix the reason why I need '' around some BIGINT and can NOT have '' around other BIGINT, it seems to depend on the table.... Chris Lee Mediawaveonline.com On Fri, 22 Dec 2000, Joe Stump wrote: > 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 >