Mysql Trigger to select and delete
Posted
by Karthick
on Stack Overflow
See other posts from Stack Overflow
or by Karthick
Published on 2010-06-15T00:36:48Z
Indexed on
2010/06/15
0:42 UTC
Read the original article
Hit count: 156
mysql
Hi,
Is this possible, can a trigger in mysql can do a select first and then based on its result do a delete?, both on the same table.
Am struggling to get it right.
There are duplicate entries in a table, i need to have a trigger which selects and then deletes.
Any ideas or thoughts will be really helpful.
© Stack Overflow or respective owner