Escaping confusion with Python 3 + MySQL
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?
More information about the Python-list