九州编程
我遇到了这个问题,虽然解决方案有效,但后来我遇到了一种感觉更好的解决方案。当这个问题最初被回答时,我怀疑这不是一个选择。CREATE TRIGGER `TestTable_SomeTrigger`BEFORE UPDATE ON `test_table`FOR EACH ROWBEGIN
DECLARE msg VARCHAR(255);
IF (SomeTestToFail = "FAIL!") THEN
set msg = "DIE: You broke the rules... I will now Smite you, hold still...";
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = msg;
END IF;
-- Do any other code here you may want to occur if it's all OK or leave blank it will be
-- skipped if the above if is trueEND$$这将返回一个好的(或邪恶!)您可以捕获的错误消息。有关此问题的更多信息,请参见:http:/dev.mysql.com/doc/refman/5.5/en/signal.html我希望这能帮到别人!