> i dont have to update table set column1 = this value, column2=that value and
> so on
Why do you think so? Did you really read the manual?
mysql> create table test_update (a int primary key, b int, c int);
Query OK, 0 rows affected (0.02 sec)
mysql> insert into test_update values (1, 2, 3);
Query OK, 1 row affected (0.00 sec)
mysql> update test_update set (b, c) values (4, 5) where a = 1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '(b, c) values (4, 5) where a = 1' at line 1
mysql> update test_update set b=4, c=5 where a = 1;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
>
> It's just when the LIKE clause jumps in that is causing all this trouble....
Your MariaDB said:
> check the manual that corresponds to your MariaDB server version for the
> right syntax to use near '(pagesID, host, ...
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?
--
https://mail.python.org/mailman/listinfo/python-list
