I want to log every
insert,delete,update (successfully written) queries using mysql ? I tried following ways
triggers ( but i can't get the SQL query );
show processlists ( only showing select queries )
3) mysql proxy ( didn't try but heard that can be monitor queries )
How can i achieve this ?