-> DELIMITER |
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 '' at line 4
mysql> CREATE TRIGGER DEC_check_insert AFTER INSERT ON `maindata` FOR EACH ROW BEGIN
    -> IF NEW.DECd < 0 OR NEW.DECm < 0 OR NEW.DECs THEN
    ->  IF NEW.DECd > 0 then
    ->     UPDATE `maindata` SET NEW.DECd = NEW.DECd * (-1); -- WHERE NEW.DECd > 0 AND (NEW.DECs < 0 OR NEW.DECm < 0);
    ->  END IF;
    ->  IF NEW.DECm > 0 then
    ->     UPDATE `maindata` SET NEW.DECm = NEW.DECm * (-1); -- WHERE NEW.DECm > 0 AND (NEW.DECs < 0 OR NEW.DECd < 0);
    ->  END IF;
    ->  IF NEW.DECs > 0 then
    ->     UPDATE `maindata` SET NEW.DECs = NEW.DECs * (-1); -- WHERE NEW.DECs > 0 AND (NEW.DECd < 0 OR NEW.DECm < 0);
    ->  END IF;
    -> END IF;
    -> END;
    -> |
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation