KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
i've got some code that is triggering a syntax error because of some misplaced semicolons. if this was running on the command line, i'd solve this with a delimiter. unfortunately, the jdbc4 driver doesn't seem to recognize delimiters. anyway to get this to run? delimiter | CREATE TRIGGER obs_update BEFORE UPDATE ON obs FOR EACH ROW BEGIN IF OLD.voided = 0 AND NEW.voided = 1 THEN DELETE FROM clinic_obs WHERE id = OLD.obs_id; ELSE UPDATE clinic_obs SET clinic_obs.revision_token = NOW() WHERE NEW.obs_id = clinic_obs.id; END IF; END; | delimiter ;
Tags (comma-separated)
Save Edits
Cancel