[ale] delete rows in mysql

[Chris Fowler]

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