I'm using a trigger to capture an audit trail. I want to convert the inserted / updated / deleted value to XML and store it in another table.
My trigger look like this:
DELIMITER $$ CREATE TRIGGER `MyDB`.`TriggerAudit` AFTER INSERT ON `MyDB`.`settings` FOR EACH ROW BEGIN INSERT INTO insert_audit_trail (user_uid, table_name, inserted_value) VALUES ('the Username', 'the table name', 'Select to XML In Here') END$$ DELIMITER ;
In MS SQL Server I can use the FOR XML clause, but I don't know to do this in MySQL. Is there any solution for this?