filburt1
12-11-2002, 08:18 PM
REPLACE INTO hourlypoststat
VALUES (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23),
(941, 1006, 560, 597, 534, 533, 664, 888, 978, 1225, 1670, 2017, 1707, 1886, 1981, 2658, 3196, 4150, 4418, 3134, 3503, 3523, 2600, 1595);
hourlypoststat is:
mysql> DESCRIBE hourlypoststat;
+-----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| hourofday | int(11) | | | 0 | |
| postcount | int(11) | | | 0 | |
+-----------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
No matter what I do I constantly get the error Column count doesn't match value count at row 1. WTH is going on!? :mad:
VALUES (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23),
(941, 1006, 560, 597, 534, 533, 664, 888, 978, 1225, 1670, 2017, 1707, 1886, 1981, 2658, 3196, 4150, 4418, 3134, 3503, 3523, 2600, 1595);
hourlypoststat is:
mysql> DESCRIBE hourlypoststat;
+-----------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| hourofday | int(11) | | | 0 | |
| postcount | int(11) | | | 0 | |
+-----------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)
No matter what I do I constantly get the error Column count doesn't match value count at row 1. WTH is going on!? :mad: