How to log requests, actions in a separate table?

Question

PHP

Hello, is it possible to do logging (recording admin actions) directly into a separate database table? I tried it with a trigger, but somehow it didn’t work out very well, here is an example
BEGIN
INSERT INTO `log` (`name`) VALUES (CONCAT(NEW.`login`),
NOW()) ;
END
Can you give an example too? Everywhere there are examples of writing to a log file, but for me it is in a table.

Answer 1

CQRS + Event Sourcing

Answer 2

да... не в моде нынче поиск.
Как записывать все запросы в таблицу?