ansaurus

Question

Trouble with MySQL UPDATE syntax with the module mysqldb in Python

Answer 1

A:

It looks like query is formed with wrong syntax. Could you display string parameter of cursor.execute?

2010-01-31 08:57:49

For example, putting in actual strings instead of %s, the above query would like like:UPDATE tablename SET columnname = "something" WHERE another_column_name = "something_else"The error is suggesting that my where clause is searching for the column "something else" rather than the column another_column_name with the value "something_else"

curious 2010-01-31 09:02:37

I've tried the query with real strings in MySQL directly and that seemed to work. I believe the trouble is with the syntax around %s, or the way I am using cursor.execute ...

curious 2010-01-31 09:03:34

I mean that you should check EXACT (calculated) parameter of execute in debugger.

2010-01-31 19:35:13

Answer 2

+1 A:

i see now, i think you need to enclose parameter_set_name = %s in quotes such as:

parameter_set_name = "%s"

otherwise it's trying to acces column M1

so:

cursor.execute("""UPDATE parameters SET %s = %s WHERE parameter_set_name = \"%s\" """ % (i, float(getattr(self.p, i)), self.list_box_parameter.GetStringSelection()))

pulegium 2010-01-31 09:00:50

That worked!! Thank you :) Why do I need the quotes for the third case of %s but not the 2nd case?

curious 2010-01-31 09:06:14

i'm guessing mysql sees a float number which cannot be column name so just works out that it's a value rather than a name

pulegium 2010-01-31 09:09:16

Cool -- thank you :)

curious 2010-01-31 09:11:23

ansaurus

tags:

views:

answers:

Trouble with MySQL UPDATE syntax with the module mysqldb in Python

related questions