Re: ERROR in syntax...

2014-09-06 Thread hsv
2014/09/06 09:06 -0700, Don Wieland Can anyone tell me why this query is generating an ERROR: Which error? The first "IF" statement is not properly ended? it isn't. (A series of equality tests against the same variable is done more conveniently with "CASE ... END CASE".) --

ERROR in syntax...

2014-09-06 Thread Don Wieland
Can anyone tell me why this query is generating an ERROR: DROP TRIGGER rtsadven_development.content_assets_after_insert_subtypes; CREATE TRIGGER `rtsadven_development`.`content_assets_after_insert_subtypes` AFTER INSERT ON `rtsadven_development`.`content_assets` FOR EACH ROW BEGIN IF N