CHECK constraint in MySQL is not working

by

MySQL 8.0.16 is the first version that supports CHECK constraints.

Read https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html

If you use MySQL 8.0.15 or earlier, the MySQL Reference Manual says:

The CHECK clause is parsed but ignored by all storage engines.

Try a trigger…

mysql> delimiter //
mysql> CREATE TRIGGER trig_sd_check BEFORE INSERT ON Customer 
    -> FOR EACH ROW 
    -> BEGIN 
    -> IF NEW.SD<0 THEN 
    -> SET NEW.SD=0; 
    -> END IF; 
    -> END
    -> //
mysql> delimiter ;

Hope that helps.

More Related Contents:

  1. CHECK constraint in MySQL is not working
  2. How do I add a custom CHECK constraint on a MySQL table?
  3. 1052: Column ‘id’ in field list is ambiguous
  4. Codeigniter – multiple database connections
  5. How to add levenshtein function in mysql?
  6. #1071 – Specified key was too long; max key length is 1000 bytes
  7. MySQL – UPDATE query with LIMIT
  8. Differences between utf8 and latin1
  9. phpMyAdmin on MySQL 8.0 [duplicate]
  10. MySQL stored procedures use them or not to use them
  11. Change decimal separator in MySQL
  12. SQL query of multiple values in one cell
  13. Fetching linked list in MySQL database
  14. How to retrieve the current version of a MySQL database management system (DBMS)?
  15. How can I correct MySQL Load Error
  16. Using ALTER to drop a column if it exists in MySQL
  17. Count number of unique values
  18. ‘Access denied for user ‘root’@’localhost’ (using password: NO)’
  19. Meaning of “n:m” and “1:n” in database design
  20. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  21. Count with IF condition in MySQL query
  22. How to format number with “.” as thousands separator and “,” as decimal separator?
  23. Using DISTINCT and COUNT together in a MySQL Query
  24. Error installing mysqlclient for python on Ubuntu 18.04
  25. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  26. MySQL Alter table causes Error: Invalid use of NULL value
  27. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  28. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  29. Migrating data into Firebase from MySQL
  30. Inventory management with stock options

Leave a Comment