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/
Subject
Views
Written By
Posted
2027
September 23, 2012 09:58AM
Re: Trigger
1481
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.