svidelo mi se logovanje u tabelu. evo primer:
-- odaberemo neku bazu, nije obavezno, ili startujemo neki program ili nista
USE pd460;
-- preusmerimo log u tabelu, mysql.general_log
set global log_output='TABLE';
-- ispraznimo tabelu
TRUNCATE table mysql.general_log;
-- ukljucimo logovanje
set general_log=1;
-- kuckamo SQL ili pustimo test...
SELECT TRT FROM MRT;
INSERT INTO MRT (TRT) VALUES ('trt');
-- onda iskljucimo logovanje
set general_log=0;
-- pogledamo statistiku, na primer:
SELECT * FROM general_log WHERE argument NOT IN ('SET autocommit=0', 'SET autocommit=1', 'commit', 'select @@session.tx_read_only', 'set session transaction read only', 'set session transaction read write');
SELECT * FROM general_log WHERE argument LIKE 'INSERT%';
SELECT * FROM general_log WHERE argument LIKE 'UPDATE%';
SELECT * FROM general_log WHERE argument LIKE 'DELETE%';
Acta, non verba!