Recently, someone emailed me:I have a requirement in MYSQL as
we have a table
EMP and we have to restrict the
users not delete employees with
DEPT_ID = 10. If
user executes a
DELETE statement without giving any
WHERE condition all the rows should be deleted
except those with
DEPT_ID = 10.
We are trying to write a
BEFORE DELETE trigger but
we are not able to get this functionality.
I have seen your blog where you explained about …