Re: what is mysql complaining about ?

From: Date: Fri, 22 Dec 2000 18:36:33 +0000
Subject: Re: what is mysql complaining about ?
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-31606@lists.php.net to get a copy of this message
oi, I forgot the ', ' Chris Lee Mediawaveonline.com In article <20001222103834.C32655@zorka.com>, "Joe Stump" <joe@earth.care2.com> 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', >> '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 >> >>

« previous php.general (#31606) next »