All pastes #32804 Raw Edit

Miscellany

public text v1 · immutable
#32804 ·published 2005-12-07 15:45 UTC
rendered paste body
mysql> CREATE TRIGGER keywordbuilder AFTER INSERT ON campaigns
    -> FOR EACH ROW BEGIN
    -> INSERT INTO campaigns SET ca_keyword = NEW.ca_id;
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 'INSERT INTO campaigns SET ca_keyword = NEW.ca_id' at line 3