There are three kinds of people in this world;
those who can count, and those who can't.
Ray wrote:
You are inserting 6 values into 7 fields, so it fails.
looks like a 6 field table to me
create table if not exists MSFT (date DATE not null, close
DECIMAL(10,2), high DECIMAL(10,2), low DECIMAL(10,2), volume MEDIUMINT,
yest DECIMAL(10,2), PRIMARY KEY date (date));
1) date
2) close
3) high
4) low
5) volume
6) yest
7) PRIMARY KEY -- Not a field, unless they REALLY changed things in MySQL 4
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
