Neha Choudhary
Reputation: 4870
How to restrict a row from getting deleted from a table through a query?
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?
Upvotes: 1
Views: 130
Answers (1)
Dan
Reputation: 2093
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.
Upvotes: 3
Related Questions
- MySQL doesn't prevent deletion of rows where primary key is associated with another table
- MYSQL deleting a record
- How to delete from table but to prevent it from becoming empty?
- MySQL Deleting based upon a query result
- Protect row from deletion in MySQL
- How to prohibit the removal of any rows in a specific mysql table?
- MySQL/SQL prevent deleting records that are use in another table
- Preventing the deletion of a specific row in a database
- Excluding a specific record from a delete query
- mysql prevent deleting records that is in used