update 表1 set flag='d' from 表2 where pay like '%货到付款%';
执行sql语句时,出现错误,请问哪里出错了。
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 'from 表2 where pay like '%货到付款%'' at line 1