[ale] delete rows in mysql

Chris Fowler cfowler at outpostsentinel.com
Wed May 5 15:54:47 EDT 2010


On Wed, 2010-05-05 at 15:19 -0400, James Sumners wrote:
> I guess I started down the subquery path because you were leading ;)
> 
> Let's simplify this some:
> 
> DELETE FROM  trigger USING trigger INNER JOIN trigger_group_map WHERE
> trigger.trigger_id = trigger_group_map.trigger_id AND
> trigger_group_map.trigger_group_id = 3;

Wow.  Works great.





More information about the Ale mailing list