Is it possible to detect when a row is tried to be deleted and stop it from deleting?
let's take a simple row:
name id
rag 4
I do not want this row deleted somehow using trigger or ?
How to stop a row from being deleted using trigger?
Moderator: General Moderators
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
I am working on mysql.timvw wrote:Which SQL DBMS are you using? Most have a TRIGGER INSTEAD OF DELETE construct...
I do not want anyone to accidentally delete some important rows in tables which are meant to be there all the time. I want to stop people from deleting it somehow.
timvw, do you know any good editor for triggers, because navicat or query browser do not support triggers properly. Use of 'show triggers' does give us only the body of the trigger which is not really so useful.
Thanks