56,679
社区成员
发帖
与我相关
我的任务
分享update与left join结合问题
update c set s='3'
from ccc as c
left join aaa a
on c.cid=a.eid
where a.type='01' and c.s='1' and (c.p=2807 or a.op=2807)
请教一下，这个sql语句怎么会报错呢？
[Err] 1064 - 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 ccc as c
left join aaa as a
on c.cid=a.eid
where a.t' at line 2
请不吝赐教！
...全文
请发表友善的回复…
发表回复
尔东主机 2017-02-22
- 打赏
- 举报
update ccc,aaa set ccc.s='3'
where c.cid=a.eid and a.type='01' and c.s='1' and (c.p=2807 or a.op=2807)
mikeccn 2017-02-22
- 打赏
- 举报
谢谢大家的回复！
ACMAIN_CHM 2017-02-16
- 打赏
- 举报
少了 SET
update c set s='3'
from ccc as c
left join aaa a
on c.cid=a.eid
set ???????
where a.type='01' and c.s='1' and (c.p=2807 or a.op=2807)
zjcxc 2017-02-16
- 打赏
- 举报
update ccc as c
left join aaa a
on c.cid=a.eid
set s='3'
where a.type='01' and c.s='1' and (c.p=2807 or a.op=2807)
mikeccn 2017-02-16
- 打赏
- 举报
我写的sql语法似乎没错，难道是mysql 版本问题？
麦克尔 2017-02-16
- 打赏
- 举报
关注！我也碰到类似问题！
