Skip navigation links

MySQL Forums :: Newbie :: Table behaving strangely, queries don't take effect


Advanced Search

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 ( http://pastebin.com/FuSxm1KA ), the table looks like so: http://d.pr/i/RrRk

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


Subject Written By Posted
Table behaving strangely, queries don't take effect Bror Bojlen 04/27/2012 07:04AM
Re: Table behaving strangely, queries don't take effect Bror Bojlen 04/27/2012 03:12PM
Re: Table behaving strangely, queries don't take effect laptop alias 04/27/2012 05:47PM


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.