•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 330,173 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,272 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.
Please support our MySQL advertiser:
Views: 144 | Replies: 1
 |
•
•
Join Date: Sep 2007
Posts: 9
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I have a ton of inserts in an sql file that look like this:
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...
INSERT INTO grades (GWid, classid, semester, year, grade, required) VALUES(100000089, 'CS210', 'B', 'fall', '2006', 'yes');
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 : 7 Days Ago at 4:55 am. Reason: fixed problem
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
DaniWeb Marketplace (Sponsored Links)
Linear Mode
Similar Threads
- In desperate need of help with iterative insert method for avl tree. please help (Java)
- Insert to DB & View Results on Different Page (ASP.NET)
- Insert to multiple tables (ASP.NET)
- how to insert variables into string with % sign? (C++)
- insert in mysql (PHP)
- image database (MySQL)
- Cannot delete file (Windows 9x / Me)
- JavaScript's window.opener (JavaScript / DHTML / AJAX)
Other Threads in the MySQL Forum
- Previous Thread: SMS Message and Email Message
- Next Thread: MySQL Error 1064 when DELETEing
