Log when a row is deleted from a given table in MySQL

Question

I have a MySQL-table that's accessed from different APIs. I would like to log when any rows are deleted from this table. Is this possible?

Answer 1

Yes, you can use a simple trigger, something like;

CREATE TRIGGER data_delete BEFORE DELETE ON data FOR EACH ROW
BEGIN
  INSERT INTO log(logmessage) VALUES (CONCAT('Delete of value ', OLD.id));
END

A simple SQLfiddle demo.

Answer 2

Yes it is possible. You have to use trigger for this purpose. Using triggers you can save the data, time and other information after the delete occurs.