Re: MySQL "Update" statement is failing with syntax error

You are quoting your strings twice. You use both q{} and "". So the command that's being send is

    "UPDATE my_table SET MY_COLUMN = '' WHERE MY_OTHER_COLMN = 'my_val
+ue'"
[download]

including your quotes.

I'm a bit amazed it doesn't complain about the SELECT, where you make the same error.

Comment on Re: MySQL "Update" statement is failing with syntax error Download Code

Replies are listed 'Best First'.
Re^2: MySQL "Update" statement is failing with syntax error by psini (Deacon) on Aug 27, 2008 at 21:35 UTC
It's easy: AFAICS he didn't check the result of SELECT... Rule One: "Do not act incautiously when confronting a little bald wrinkly smiling man."	[reply]