2 tags edited
source | link

which Which table was updated by the last query?

When I perform an update query, MySQL server gives me information about how many rows were updated. But I wish to know in which table they were updated. Is that information somewhere available?

theThe query is something like

UPDATE t1
JOIN t2 ON t1.a=t2.b
SET t1.x=1, t2.y=t1.z
WHERE ....

8 rows affected...

But in which table? t1 or t2?

which table was updated by the last query?

When I perform an update query, MySQL server gives me information about how many rows were updated. But I wish to know in which table they were updated. Is that information somewhere available?

the query is something like

UPDATE t1
JOIN t2 ON t1.a=t2.b
SET t1.x=1, t2.y=t1.z
WHERE ....

8 rows affected...

But in which table? t1 or t2?

Which table was updated by the last query?

When I perform an update query, MySQL server gives me information about how many rows were updated. But I wish to know in which table they were updated. Is that information somewhere available?

The query is something like

UPDATE t1
JOIN t2 ON t1.a=t2.b
SET t1.x=1, t2.y=t1.z
WHERE ....

8 rows affected...

But in which table? t1 or t2?

1
source | link

which table was updated by the last query?

When I perform an update query, MySQL server gives me information about how many rows were updated. But I wish to know in which table they were updated. Is that information somewhere available?

the query is something like

UPDATE t1
JOIN t2 ON t1.a=t2.b
SET t1.x=1, t2.y=t1.z
WHERE ....

8 rows affected...

But in which table? t1 or t2?