MySQL Forums
Forum List  »  Triggers

Re: Trigger
Posted by: Devart Team
Date: September 25, 2012 12:50AM

Solution 1: Make the field UNSIGNED and enable STRICT_ALL_TABLES sql mode. For example -

ALTER TABLE request CHANGE COLUMN number number INT(11) UNSIGNED DEFAULT NULL
'STRICT_ALL_TABLES' - Enable strict mode for all storage engines. Invalid data values are rejected.

Solution 2,3: Call nonexistent stored procedure from the trigger, or use SIGNAL statement in MySQL 5.5 or higher to raise an error.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
1647
September 23, 2012 09:58AM
Re: Trigger
1208
September 25, 2012 12:50AM


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.