Escaping confusion with Python 3 + MySQL

Chris Angelico rosuav at gmail.com
Sun Mar 26 22:42:46 EDT 2017


On Mon, Mar 27, 2017 at 1:39 PM, Νίκος Βέργος <me.on.nzt at gmail.com> wrote:
>> MariaDB / MySQL shows part of your SQL from where they failed to parse.
>> In your case, your MariaDB can't parse from '('
>> LIKE clause is not problem for this issue?
>
> Yes indeed it is.
> I was just so sure that UPDATE was working like INSERT and i was persistent that the WHERE LIKE clause was cauing this.
>
> I'am still surprised that:
>> mysql> update test_update set (b, c) values (4, 5) where a = 1;
>
> is failign to parse. It just seems so undoubtly straightforward and correct syntactically.

So when people told you to read the docs, what did you do, exactly?

ChrisA


More information about the Python-list mailing list