on ignore

[BubikolRamios]

trigger: after insert into table1

insert ignore into table2

Any chance to do something with records that were ignored (like putting them into another table), or I'm out of luck ?

[Old Pedant]

I don't know a way to do it.

But one easy way would be to use a Stored Procedure and forget about the trigger.

In the Procedure, you would attempt the INSERT and, if you get an error from it, then do the other operation (e.g, put data into another table).

I think triggers are over-used and stored procedures are under-used, especially with MySQL.