Search code examples
mysqltriggersinsertsimulate

MYSQL : Manual simulation of the triggering event

MYSQL:

I have a table with a AFTER INSERT ON trigger on it.

I have inserted a million rows in the table and the trigger code successfully gets executed and updates 10 other tables.

Now, I have deleted the data from the 10 children tables but the million rows in the parent table is retained.

Can I manually simulate that trigger code for those million records in the parent table to reinsert them in the 10 children tables...???

Solution

  • No you can't. Only actual, successful INSERTs trigger before/after insert triggers.