MySQL Forums
Forum List  »  Triggers

Negate INSERT
Posted by: Jorge Ferreira
Date: June 28, 2006 04:22AM

Hello everyone,
It is said in White Pappers that we should use triggers because:
...
You can use them to check for, and prevent, bad data entering the database.
You can change or negate the INSERT, UPDATE, and DELETE statements.
...
And that's ok, but how can i negate (deny) a INSERT, UPDATE or DELETE statment through a trigger?
Does anyone has an example of code to do it?

Thank you,
Jorge

Options: ReplyQuote


Subject
Views
Written By
Posted
Negate INSERT
5173
June 28, 2006 04:22AM
9373
June 28, 2006 10:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.