I have a ton of inserts in an sql file that look like this:
INSERT INTO grades (GWid, classid, semester, year, grade, required)
VALUES(100000089, 'CS210', 'B', 'fall', '2006', 'yes');
but when I get my filled tables, the semester and grades are all null and the year is 0000. Any explanations as to why this would be happening?
I'm using phpMyAdmin 2.6.4-pl4 with MySQL 3.23.32 (maybe higher). It's on a university server so I don't have any choice in the matter or privileges to change anything.
-----------------------
Crap, I just realised that the values are in the wrong order. Problem solved. Tiiiiired...