How to easily maintain auditing triggers when add a new column in Mysql
<p>Now I have created a set of triggers to audit all the changes to the table, includes Insert Delete and Update.</p>

<p>But when I add one new column to the audited table, it requires me to add one more sentence to each trigger accordingly.</p>

<p>Is there any way I can write a foreach loop within my triggers to go through all the columns no matter how many columns is and will be in the table? Thanks for any idea.</p>

<p>And is there any tool that helps us build the auditing tables? 
I am wondering since audit is a very popular use, why not mysql come up with some cmd to help us create the audit functions.</p>

<p>something like:</p>

<pre><code>Create Table MyAudit
.... 
Audit All/(col1,col2).
</code></pre>

<p>Then we can get the audit data accordingly from Audit_MyAudit. That would be great!</p>