Automatic Trigger generation for the newly created tables.

Question

Is there any script to auto generate triggers when table is created newly?

Answer 1

When a new table is created it doesn't have any trigger in it, you have to create the trigger, but if you were restoring a table from a .sql dump file, there is a possibility that the .sql file contains the backup version of the table's trigger(s), along with structure and optionally, data. The restore process will then reinstate the trigger(s), but I guess this isn't the issue you were asking for, I'm not sure I understand your question fully : )

Answer 2

please tell about table auditing using dml trigger and ddl trigger in MySQL