如何限制行通过查询从表中删除?

时间:2023-01-26 16:44:53

Is that possible? I know how to do it with a program but is there any query to do it without the support of primary or foreign key?

那可能吗?我知道如何使用程序,但有没有任何查询,没有主键或外键的支持?

1 个解决方案

#1


3  

In MySQL I don't think it is possible. If the MySQL user running query has the DELETE privilege, then they will be able to delete any row.

在MySQL中我认为不可能。如果运行MySQL查询的用户具有DELETE权限,则他们将能够删除任何行。

#1


3  

In MySQL I don't think it is possible. If the MySQL user running query has the DELETE privilege, then they will be able to delete any row.

在MySQL中我认为不可能。如果运行MySQL查询的用户具有DELETE权限,则他们将能够删除任何行。