I have a requirement in MYSQL as follows:Frankly, I usually refer people [Read more...]
we have a table
EMPand we have to restrict the users not delete employees with
DEPT_ID = 10. If user executes a
DELETEstatement without giving any
WHEREcondition all the rows should be deleted except those with
DEPT_ID = 10.
We are trying to write a
BEFORE DELETEtrigger but we are not able to get this functionality.
I have seen your blog where you explained about Using an UDF to Raise Errors from inside MySQL Procedures and/or Triggers. Will it helps me to get this functionality? Could you suggest if we have any other alternatives to do this as well?