Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren0
Automatic Trigger generation for the newly created tables.
Is there any script to auto generate triggers when table is created newly?
2 Antworten
+ 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 : )
+ 1
please tell about table auditing using dml trigger and ddl trigger in MySQL