Haim Evgi
Reputation: 125496
How can I write a trigger in mysql that after an insert to the table deletes the row?
I've got an after insert trigger that works well.
However, I want it to delete the row after it's been inserted and after the main body of the trigger completes.
How can I do that?
I have a unique id in the table.
Upvotes: 1
Views: 1463
Answers (1)
longneck
Reputation: 12226
This isn't possible. You can't modify the target table with an AFTER trigger.
Upvotes: 1
Related Questions
- Trigger delete BEFORE INSERT
- MySQL trigger on Delete, update a record?
- Trigger to insert a row into another table on delete
- Create trigger that delete after insert
- How to create a trigger for before/after delete with update/insert in mysql?
- Creating a delete trigger
- Delete row with a Mysql Trigger
- MySql Trigger, before insert delete a row in the same table
- How to DO MYSQL TRIGGER FOR DELETE Entry Before UPDATE
- SQL trigger to delete rows from database