Insert doesn't do what it's supposed to

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 375,223 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,241 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 339 | Replies: 1

Previous Post in Thread

Next Post in Thread

•

Join Date: Sep 2007

Posts: 9

Reputation: Icetigris is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Icetigris

Offline

Newbie Poster

Insert doesn't do what it's supposed to

May 6th, 2008

I have a ton of inserts in an sql file that look like this:

Help with Code Tags

(Toggle Plain Text)

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...

Last edited by Icetigris : May 6th, 2008 at 4:55 am. Reason: fixed problem