自定义错误
问题描述:
Possible Duplicate:
raise error within MySql function自定义错误
在MSSQL中,我可以提出一个自定义错误:
CREATE TRIGGER [dbo].[TR__TABLE__DisableRowOnDelete]
ON [dbo].[TABLE]
INSTEAD OF DELETE
AS
BEGIN
RAISERROR ('Data cannot be deleted.', 16, 1);
END
我怎么可能做到这一点在MySQL的?
答
在MySQL 5.5中,您可以使用SIGNAL语句,例如, -
CREATE PROCEDURE TR__TABLE__DisableRowOnDelete()
BEGIN
SIGNAL SQLSTATE '02000' SET MESSAGE_TEXT = 'Data cannot be deleted.';
END
见http://*.com/questions/465727/raise-error-within-mysql-function – Jivings 2012-01-18 16:52:11
@weston使得问题是否在SO已经存在了。 – 2012-01-18 16:57:32
@aF我很高兴我没有,或者我不会发现SIGNAL – weston 2012-01-18 16:59:39