我在mysql中创建了以下触发器:
DELIMITER $$
CREATE TRIGGER `some_trigger` AFTER INSERT ON db1.table
FOR EACH ROW
BEGIN
IF NEW.userid = 'certain_id' THEN
INSERT INTO db2.table
SET
value1 = NEW.value,
value2 = NEW.value;
END IF;
END $$
DELIMITER ;如果我删除if语句,上面的语句就会起作用。另外,当将该触发器添加到db时不会遇到语法错误。你知道if语句在添加到db1.table时不允许在userid列中插入值为'certain_id‘的条目,这是怎么回事吗?
发布于 2016-08-11 18:33:40
试试这个,应该行得通..
DELIMITER $$
CREATE TRIGGER `some_trigger` AFTER INSERT ON `db1`.`table`
FOR EACH ROW
BEGIN
IF (NEW.userid = 'certain_id') THEN
INSERT INTO `db2`.`table` (value1, value2)
VALUES (NEW.value1,NEW.value2);
END IF;
END $$
DELIMITER ;https://stackoverflow.com/questions/29615039
复制相似问题