是否可以在MYSQL上禁用对表的删除? [英] Is it possible to Disable deletes on a table on MYSQL?

问题描述

我正在使用MySQL 5.0，我想知道是否存在禁用表删除的方法.就像这样，任何用户都无法从平板电脑中删除任何内容，而只能进行更新和插入.

I'm using MySQL 5.0 and I would like to know if there's a way to disable deletes on a table. As in, not make it possible for ANY user to delete anything from the tablets, only update and insert.

推荐答案

以下是触发器的示例:

DELIMITER $$

CREATE TRIGGER tr_table1_del BEFORE DELETE ON table1 FOR EACH ROW
BEGIN
  SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'DELETE cancelled'; 
END $$

DELIMITER ;

这篇关于是否可以在MYSQL上禁用对表的删除?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！