1. попробуй пробелы после запятых
2. попробуй в SELECT указывать только имя поля
Кхм - ни хрена не получается....
Может это можно как-то обойти? Типа сначала сделать SELECT того чего надо в массив
А потом уже INSERT его в бащу?
mysql> INSERT INTO completed_tasks (tid, uid) SELECT (pending_tasks.tid, pending_tasks.uid) FROM pending_tasks WHERE pending_tasks.tid = \\\'5\\\';
ERROR 1064: You have an error in your SQL syntax near \\\' pending_tasks.uid) FROM pending_tasks WHERE pending_tasks.tid = \\\'5\\\'\\\' at line 1
mysql> INSERT INTO completed_tasks (tid, uid) SELECT (tid, uid) FROM pending_tasks WHERE pending_tasks.tid = \\\'5\\\';
ERROR 1064: You have an error in your SQL syntax near \\\' uid) FROM pending_tasks WHERE pending_tasks.tid = \\\'5\\\'\\\' at line 1
mysql> INSERT INTO completed_tasks (tid, uid) SELECT (tid, uid) FROM pending_tasks WHERE tid = \\\'5\\\';
ERROR 1064: You have an error in your SQL syntax near \\\' uid) FROM pending_tasks WHERE tid = \\\'5\\\'\\\' at line 1
mysql>