Re: what is mysql complaining about ?
| From: | Chris Lee | 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
>>
>>