mysql 检查约束替代_MySQL CHECK约束替代

最新推荐文章于 2022-02-20 18:39:12 发布

蜗牛小姐CC

最新推荐文章于 2022-02-20 18:39:12 发布

阅读量215

点赞数

文章标签： mysql 检查约束替代

本文链接：https://blog.csdn.net/weixin_34264495/article/details/113149895

版权

As per the MySQL manual "The CHECK clause is parsed but ignored by all storage engines." So I know the simple solution is out of the question but is there another feasible means of coming to the same outcome? Maybe through some use of triggers or stored procedures? If so how?

Also since it is just "parsed" is that as good as saying avoid using it since it doesn't serve a purpose?

Using MySQL 5.5.11 and InnoDB tables

解决方案

Take a look at this interesting article

I often use that method.