A constraint to prevent the insert of an empty string in MySQL

by

Normally you would do that with CHECK constraint:

foo_test VARCHAR(50) NOT NULL CHECK (foo_test <> '')

Prior to Version 8.0 MySQL had limited support for constraints. From MySQL Reference Manual:

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

If you must stick to an old version use triggers as a workaround, as people have pointed out.

In future, you may want to take a look at PostgreSQL, which is considered to have better support for data integrity (among other things) by many people.

More Related Contents:

  1. How do I add a custom CHECK constraint on a MySQL table?
  2. Unique constraint that allows empty values in MySQL
  3. How to truncate a foreign key constrained table?
  4. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  5. MySQL Removing Some Foreign keys
  6. How to add not null constraint to existing column in MySQL
  7. Use Composite Primary Key as Foreign Key
  8. How to remove constraints from my MySQL table?
  9. MySQL distinction between e and é (e acute) – UNIQUE index
  10. MySQL and Check Constraints
  11. List of Constraints from MySQL Database
  12. How to do unique constraint works with NULL value in MySQL
  13. How to get a ranking result for special record in mysql [closed]
  14. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  15. How to reset AUTO_INCREMENT in MySQL
  16. MySQL Query GROUP BY day / month / year
  17. What is MySQL row order for “SELECT * FROM table_name;”?
  18. MySQL Like multiple values
  19. Error: select command denied to user ”@” for table ”
  20. MySQL Trigger: Delete From Table AFTER DELETE
  21. Return a default value if single row is not found
  22. How to find out the MySQL root password
  23. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  24. Removing duplicates with unique index
  25. Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?
  26. How to restrict a column value in SQLite / MySQL
  27. Does MySQL foreign_key_checks affect the entire database?
  28. Array data type, split string,
  29. Trouble with GROUP_CONCAT and Longtext in MySQL
  30. How can I make a table in MySQL called “order”?

Leave a Comment