MYSQL query to update data in three tables

Question

I have following three tables

Table1

+------+--------+
| GID  | Active |
+------+--------+
| 110  |  Yes   |
+------+--------+
GID is primary key

Table2

+------+--------+
| UID  | Active |
+------+--------+
| 110  |  Yes   |
| 110  |  Yes   |
+------+--------+

Table3

+------+--------+
| FID  | Active |
+------+--------+
| 110  |  Yes   |
| 110  |  Yes   |
+------+--------+

I want to update 3 tables with all the value of field Active to 'no' , how can I achieve this ? Your suggestions are highly appreciated, I hope the given information is subsequent to make a conclusion on this ?

Additional information :- Following is the query I am executing in table1 now.

  $id = 110;
  UPDATE table1 SET active = 'no' WHERE gid = {$id}"

Do you want to make all values of `Active` in all tables `No` unconditionally or there are some conditions? It is not quite clear from the question — Tigran Saluev, Jul 22 '16 at 10:35
Possible duplicate of [MySQL, update multiple tables with one query](http://stackoverflow.com/questions/4361774/mysql-update-multiple-tables-with-one-query) — KaeL, Jul 22 '16 at 10:38
@Tirgan .. I have edited the question, can you please check ? — Tom, Jul 22 '16 at 10:40

Tigran Saluev · Accepted Answer · 2016-07-22T10:42:48.103

0

This is how to update all rows with given id:

UPDATE 
    Table1, Table2, Table3
SET 
    Table1.Active = 'No', 
    Table2.Active = 'No', 
    Table3.Active = 'No'
WHERE
    Table1.GID = Table2.UID
AND Table2.UID = Table3.FID
AND Table3.FID = 110;

edited Jul 22 '16 at 10:42

answered Jul 22 '16 at 10:37

Tigran Saluev

3,351
2
26
40

MYSQL query to update data in three tables

1 Answers1