0

Is it possible to turn on the history of a particular table that are being executed in MySql 8.x?. I need it to monitor a particular table particularly delete and updated statement.

Please help, thanks in Advance.

Samir
  • 6,658
  • 3
  • 16
  • 27
  • May be this link will help you out https://stackoverflow.com/questions/650238/how-to-show-the-last-queries-executed-on-mysql – Zeeshan Zubair Feb 18 '21 at 07:01
  • For queries which alters table's data - create BEFORE triggers pack. Query INFORMATION_SCHEMA.PROCESSLIST and store current query text into service logtable. For SELECT queries - only General Log may help. – Akina Feb 18 '21 at 07:39
  • @ZeeshanZubair the answer (https://stackoverflow.com/questions/650238/how-to-show-the-last-queries-executed-on-mysql )is for the whole schema not for a particular table. – Samir Feb 18 '21 at 08:58

0 Answers0