如何基于另一个表列更新表?
这是我的SQL。我正在使用MySQL。
UPDATE tb_notify SET alert = '0' WHERE post_id = '01' AND (HERE IS I WANT TO GET BASED ON ANOTHER TABLE)
另一个表是tb_post,每个表中的参数相同。那是post_id。
tb_notify
have 3 column:
1. com_id
2. post_id
3. alert
tb_post
have 3 column:
1. post_id
2. uid_post <-- Here I want to based on this column
3. post
请帮忙。谢谢
您可以使用join进行更新
update tb_notify tn
join tb_post tp on tp.post_id = tn.post_id
set
tn.alert = '0'
where
tn.post_id = '01'
AND tp.uid_post = {whatever you want}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句