Can a MySQL trigger simulate a CHECK constraint? [duplicate]

by

when you are updating data :

delimiter $$
create trigger chk_stats1 before update on stats 
  for each row 
   begin  
    if  new.month>12 then
        SIGNAL SQLSTATE '45000'   
        SET MESSAGE_TEXT = 'Cannot add or update row: only';
      end if; 
      end; 
      $$

when you are inserting data :

   delimiter $$
    create trigger chk_stats before insert on stats 
      for each row 
       begin  
      if  new.month>12 then
       SIGNAL SQLSTATE '45000'   
       SET MESSAGE_TEXT = 'Cannot add or update row: only';
       end if; 
    end; 
    $$

these trigger will work as check constraint ,work before insert or update and check month, if month >12 gives error .

More Related Contents:

  1. Throw an error preventing a table update in a MySQL trigger
  2. How to abort INSERT operation in MySql trigger?
  3. MySQL Trigger after update only if row has changed
  4. How do I add a custom CHECK constraint on a MySQL table?
  5. Unique constraint that allows empty values in MySQL
  6. How to program a MySQL trigger to insert row into another table?
  7. TRIGGERs that cause INSERTs to fail? Possible?
  8. How to truncate a foreign key constrained table?
  9. MySQL Fire Trigger for both Insert and Update
  10. MySQL trigger On Insert/Update events
  11. MySQL error 1436: Thread stack overrun, with simple query
  12. A constraint to prevent the insert of an empty string in MySQL
  13. MySQL trigger to update a field to the value of id
  14. mysql trigger stored trigger is already used by statement which invoked stored trigger
  15. My MySQL trigger doesn’t work, simple syntax, not complicated
  16. MySQL Removing Some Foreign keys
  17. How to add not null constraint to existing column in MySQL
  18. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  19. MySQL Trigger: Delete From Table AFTER DELETE
  20. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  21. Can I launch a trigger on select statement in mysql?
  22. Use Composite Primary Key as Foreign Key
  23. Using MySQL triggers to log all table changes to a secondary table
  24. MySQL and Check Constraints
  25. MySQL: How do I use delimiters in triggers?
  26. List of Constraints from MySQL Database
  27. MySQL listen notify equivalent
  28. MySQL disable all triggers
  29. Calling an url from a trigger in mysql
  30. How to do unique constraint works with NULL value in MySQL

Leave a Comment