How do I add a custom CHECK constraint on a MySQL table?

by

CHECK constraints are not supported by MySQL. You can define them, but they do nothing (as of MySQL 5.7).

From the manual:

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

The workaround is to create triggers, but they aren’t the easiest thing to work with.

If you want an open-source RDBMS that supports CHECK constraints, try PostgreSQL. It’s actually a very good database.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  3. 1052: Column ‘id’ in field list is ambiguous
  4. How to do a batch insert in MySQL
  5. Count the occurrences of DISTINCT values
  6. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  7. MySQL Trigger after update only if row has changed
  8. difference between primary key and unique key
  9. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  10. MySQL Query to select data from last week?
  11. Cast int to varchar
  12. Import SQL file into mysql
  13. How to change the default port of mysql from 3306 to 3360
  14. Does mysql have the equivalent of Oracle’s “analytic functions”?
  15. How to skip certain database tables with mysqldump?
  16. “where 1=1” statement [duplicate]
  17. How to set a MySQL row to READ-ONLY?
  18. Laravel join with 3 Tables
  19. MySQL: LAST_INSERT_ID() returns 0
  20. Difference between two table structure
  21. Calculating a Moving Average MySQL?
  22. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  23. How to insert a file in MySQL database?
  24. Strings as Primary Keys in MYSQL Database [closed]
  25. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  26. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  27. How to speed up sql queries ? Indexes?
  28. MySQL: Computed Column
  29. Optimistic locking in MySQL
  30. mySQL SELECT upcoming birthdays

Leave a Comment