Re: HELP PLEASE!

[Stalin Lema]

Thank you Peter. I now have this error #1136 - Column count doesn't match value count at row 1. I think is after the date that I'm going wrong.

S_ID VARCHAR(6),
S_LAST VARCHAR(30),
S_FIRST VARCHAR(30),
S_MI VARCHAR(1),
S_ADDRESS VARCHAR(25),
S_CITY VARCHAR(10),
S_STATE CHAR(4),
S_ZIP VARCHAR(8),
S_PHONE VARCHAR(15),
S_CLASS CHAR(15),
S_DOB DATE,
S_PIN VARCHAR(5),
F_ID INTEGER(3),
TIME_ENROLLED INTEGER(255),

and the corrected values:

INSERT INTO STUDENT VALUES
('JO100','Jones','Tammy','R','1817 Eagleridge Circle','Tallahasse','FL','32811','7155559876','SR',DATEDIFF(NOW(), "2011-08-01"), "2011-08-01" + INTERVAL 1189 DAY, NOW());

thanks for your time