[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 14:51:24 -0400
- In-reply-to: <[email protected]>
- References: <1273066975.2621.486.camel@cfowler-desktop> <[email protected]> <1273075849.2621.501.camel@cfowler-desktop> <[email protected]>
On Wed, 2010-05-05 at 13:36 -0400, James Sumners wrote:
>
> DELETE FROM trigger a WHERE a.trigger_id IN (SELECT b.trigger_id FROM
> trigger_group_map b WHERE b.trigger_group_id = 3)
I tried doing something like that months ago.
mysql> DELETE FROM trigger a WHERE a.trigger_id IN (SELECT b.trigger_id
FROM
-> trigger_group_map b WHERE b.trigger_group_id = 3);
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'WHERE a.trigger_id IN (SELECT b.trigger_id FROM
trigger_group_map b WHERE b.trig' at line 1