Return to Question

	2	tags edited source \| link	edit approved Jul 3 at 17:27 Glorfindel 1,2281 gold badge9 silver badges16 bronze badges
inline side-by-side side-by-side markdown 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? mysql update

	1	source \| link	asked Jul 3 at 16:21 user2106769 211 bronze badge
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? mysql

Database Administrators Stack Exchange works best with JavaScript enabled