MySQL Forums
Forum List  »  Newbie

Table behaving strangely, queries don't take effect
Posted by: Bror Bojlen
Date: April 27, 2012 07:04AM

I've written a script that adds student data (name and classes) to a table one at a time. The table is structured so that there is a primary key column, a student name column, and then a column for each class. The script checks to see if the class it's adding already exists as a column, and if not it creates it. Then it writes 'true' under that column for the current student.

Here's my problem: from the log file I can see that every single query is sent to MySQL correctly, but some don't show up in the table. When I run these queries ( ), the table looks like so:

That is, the final query "UPDATE Students SET 3uth1='true' WHERE idStudents='1'" doesn't go through.

I hope this makes sense, and someone can shed some light on this issue - it's driving me crazy.

Options: ReplyQuote

Written By
Table behaving strangely, queries don't take effect
April 27, 2012 07:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.