MySQL Trigger promlem
DELIMITER $$ CREATE TRIGGER `update_features` AFTER INSERT ON `jos_cbsubs_plans` BEGIN DECLARE itype varchar(16); SET itype := 'usersubscription'; IF NEW.item_type = itype THEN INSERT INTO jos_cbsubs_dya_subscription_features (subs_id,published) VALUES (NEW.id,NEW.published); END IF; END $$ DELIMITER ;
#1064 - 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 'BEGIN
DECLARE itype varchar(16);
SET itype := 'usersubscription';
IF NEW.ite' at line 2
Reduce stress | Stay focused | Keep positive and balanced
-- Lisa G
Reduce stress | Stay focused | Keep positive and balanced
-- Lisa G
Reduce stress | Stay focused | Keep positive and balanced
-- Lisa G
Dr. Samuel Johnson (Presiding at the sale of Thrales brewery, London, 1781)