my application connects to a MySQL database, which is externally updated by users and also by my software. However, I do need

1) a trigger, signal or something similar, so that I get to know when a change has been done
2) a list of the changes

I need those two information, so that I can afterwards update the database myself with information related to the changes caster from the users. I found a couple of general solutions for submitting a SQL query, however the QSqlQuery seemed to have problems with multi-line queries.

Do you know how this can be done elegantly and efficiently?