what is mysql complaining about ?
| From: | Chris Lee | Date: | Fri, 22 Dec 2000 18:34:16 +0000 |
| Subject: | what is mysql complaining about ? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-31604@lists.php.net to get a copy of this message | ||
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',
mysql> '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