Code: Select all
UPDATE table1 SET user = 1 WHERE user IN (2,3);
UPDATE table2 SET user = 1 WHERE user IN (2,3);
UPDATE table3 SET user = 1 WHERE user IN (2,3);
...
Moderator: General Moderators
Code: Select all
UPDATE table1 SET user = 1 WHERE user IN (2,3);
UPDATE table2 SET user = 1 WHERE user IN (2,3);
UPDATE table3 SET user = 1 WHERE user IN (2,3);
...
Code: Select all
UPDATE
table1 t1 JOIN table2 t2 USING(user) JOIN table3 t3 USING(user)
SET user = 1Code: Select all
UPDATE t1 JOIN t2 USING (user) JOIN t3 USING (user) SET t1.user = 2, t2.user = 2, t3.user = 2