MySQL Update Statement doesn't work

Question

My update statement in MySQL doesn't appear to be working:

timeup = "UPDATE timeid set time=\"" + str(timeid) + "\""
c.execute(timeup)

I've tried everything I thought might be wrong with it, including changing the type of the variable (as you can see above, I have it as a string) and using and not using quotes.

I can even print out what the statement turns into:

UPDATE timeid set time="224215313716215808"

The only column and value that timeid has is time and 0, respectively.

Why isn't this updating? Am I doing something wrong?

Nick Freeman · Accepted Answer · 2013-04-15 18:57:38Z

2

You need to use:

c.commit();

since MySQLdb begins a transaction for update statements.

edited Apr 15, 2013 at 18:57

Nick Freeman

1,4111 gold badge12 silver badges25 bronze badges

answered Apr 15, 2013 at 18:25

inaun

212 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

1' OR 1 -- · Accepted Answer · 2012-07-14 19:06:30Z

1

Try:

timeup = "UPDATE `timeid` SET `time`='" + str(timeid) + "';"
c.execute(timeup)

Time might be a constant in SQL and therefore using the simple quotation marks (I don't know, how they are called) ensures that you refer to a field. And try to use ' for setting the value and consider adding a semicolon.

Did you select a database before?

edited Jul 14, 2012 at 19:06

answered Jul 14, 2012 at 19:01

1' OR 1 --

1,7142 gold badges19 silver badges33 bronze badges

4 Comments

Steven Matthews Over a year ago

Yes, database is selected. I've changed my query to this: timeup = "UPDATE timeid set timestamp='" + str(timeid) + "';"

1' OR 1 -- Over a year ago

I do not know python, but maybe there is a function, which can give you some more detailled information about a possible error being returned by the MySQL-database.

Steven Matthews Over a year ago

I can't find any, tragically. This problem seems unsolvable to me - everything I'm doing seems to be right.

1' OR 1 -- Over a year ago

Does the same query you have the output of (UPDATE timeid set time="224215313716215808") work using any other software, like phpMyAdmin?

pyrometer · Accepted Answer · 2012-07-14 19:03:32Z

-1

Try to add a semicolon (;) at the end of the query and tell me if it works.

answered Jul 14, 2012 at 19:03

pyrometer

8811 gold badge8 silver badges18 bronze badges

Collectives™ on Stack Overflow

MySQL Update Statement doesn't work

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related