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: 157

Filed under:

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

Related posts about mysql