[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] delete rows in mysql
- Subject: [ale] delete rows in mysql
- From: cfowler at outpostsentinel.com (Chris Fowler)
- Date: Wed, 05 May 2010 15:54:47 -0400
- In-reply-to: <[email protected]>
- References: <1273066975.2621.486.camel@cfowler-desktop> <[email protected]> <1273075849.2621.501.camel@cfowler-desktop> <[email protected]> <1273085484.2621.514.camel@cfowler-desktop> <[email protected]>
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.