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 423,231 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 4,936 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: Programming Forums

Insert doesn't do what it's supposed to

•

•

Join Date: Sep 2007

Posts: 9

Reputation: Icetigris is an unknown quantity at this point

Icetigris is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Icetigris is offline

Offline

Newbie Poster

Insert doesn't do what it's supposed to

#1

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

Reply With Quote

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Advertisement

Statistics

Members: 423,231

Users Online Now: 4,936

Active IRC Users: 25

Forum Threads: 135,561

Forum Posts: 689,320

Code Snippets: 903

Blogs: 149

Blog Entries: 2,282

Directory Links: 571