i'm use XAMPP 1.7.7 on CenOS 6.2
get an error message
- Code: Select all
/*!50003 CREATE*//*!50017 DEFINER=`user`@`%`*//*!50003 TRIGGER fsync_trupd_20_ppsiswahadir BEFORE UPDATE ON jbsakad.ppsiswahadir FOR EACH ROW BEGIN IF @DISABLE_TRIGER IS NULL THEN IF OLD.issync = 1 THEN SET NEW.issync = 0; SET NEW.ts = CURRENT_TIMESTAMP; END IF; IF OLD.issync = 0 AND NEW.issync = 0 THEN SET NEW.ts = CURRENT_TIMESTAMP; END IF; END IF; END */ ; ;
MySQL said: Documentation
#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 'CREATE*/ /*!50017 DEFINER=`user`@`%`*/ /*!50003 TRIGGER fsync_trupd_20_ppsiswaha' at line 1