mysql2sqlite
mysql2sqlite copied to clipboard
Converting trigger -- Parse error near near "IF"
I have several triggers which in MySQL dump look like this:
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `check_zero_prefs` BEFORE INSERT ON `lang_prefs` FOR EACH ROW
BEGIN
IF (NEW.size=0 AND NEW.other_size=0) THEN
SIGNAL SQLSTATE '45003' SET MESSAGE_TEXT = 'BOTH_SIZES_ZERO';
END IF;
END */;;
DELIMITER ;
After conversion:
CREATE TRIGGER `check_zero_prefs` BEFORE INSERT ON `lang_prefs` FOR EACH ROW
BEGIN
IF (NEW.size=0 AND NEW.other_size=0) THEN
SIGNAL SQLSTATE '45003' SET MESSAGE_TEXT = 'BOTH_SIZES_ZERO';
END IF;
END ;;
When trying to use the entire SQL script sqlite3 shows an error:
Parse error near line 40: near "IF": syntax error
EFORE INSERT ON `lang_prefs` FOR EACH ROW BEGIN IF (NEW.size=0 AND NEW.other
error here ---^