如何通过单个mysql查询更新多个表? [英] How to update multiple tables by single mysql query?
本文介绍了如何通过单个mysql查询更新多个表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有两个表tb1& tb2 我必须更新两个表的公共列,即user_level 我对两个表(如用户名)都有一个通用条件.
I have two tables tb1 & tb2 I have to update a common column of both tables, i.e user_level I have a common criteria for both tables like username.
所以我想这样更新:
UPDATE tb1, tb2 SET user_level=1 WHERE username="Mr.X"
但是以某种方式它不起作用. 什么是正确的mysql查询呢?
But somehow it is not working. What would be the correct mysql query for this?
推荐答案
尝试一下:
UPDATE table_1 tb1,
table_2 tb2,
table_3 tb3
SET tb1.field2 = "some value",
tb2.field3 = "some other value",
tb3.field4 = "some another value"
WHERE tb1.field1 = tb2.field1
AND tb1.field1 = tb3.field1
AND tb1.field1 = "value"
我在MSAccess和SQL SERVER 2008上测试了代码
I tested the code on MSAccess and SQL SERVER 2008
这篇关于如何通过单个mysql查询更新多个表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文