例如
UPDATe RES_OBJECT SET MULTISELECT_ID=(SELECT MULTISELECT_ID FROM RES_OBJECT WHERe RES_ID=PARENT_NODE_RES_ID)
WHERe RES_OBJECT.MULTISELECT_ID IS NULL OR RES_OBJECT.MULTISELECT_ID=0;
mysql 如何对一张表进行嵌套查询
答案:2 悬赏:0
解决时间 2021-03-04 02:03
- 提问者网友:曖昧情执
- 2021-03-03 08:40
最佳答案
- 二级知识专家网友:承载所有颓废
- 2021-03-03 10:07
你这是更新,不是查询
update a
set a.MULTISELECT_ID=b.MULTISELECT_ID
from RES_OBJECT a,RES_OBJECT b
where (a.MULTISELECT_ID is null or
a.MULTISELECT_ID=0)
and b.RES_ID=PARENT_NODE_RES_ID
update a
set a.MULTISELECT_ID=b.MULTISELECT_ID
from RES_OBJECT a,RES_OBJECT b
where (a.MULTISELECT_ID is null or
a.MULTISELECT_ID=0)
and b.RES_ID=PARENT_NODE_RES_ID
全部回答
- 1楼网友:佛说妍妍很渣
- 2021-03-03 10:41
你的sql语句中 的 from 和 to 与sql保留关键词 有冲突。
select
a.train_no, a.sequ_no t_from , b.sequ_no t_to
from
(select * from aa where st_name= "xxx" ) as a ,
(select * from aa where st_name= "xx") as b
where
a.train_no = b.train_no and a.sequ_no
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯