CHECK constraints in MySQL

May 14, 2019

MySQL (really) supports CHECK CONSTRAINT since version 8.0.16.
In this article I will show you 2 things:
– An elegant way to simulate check constraint in MySQL 5.7 & 8.0.
– How easy & convenient it is to use CHECK constraints in 8.0.16.

Comments Off on CHECK constraints in MySQL

30 mins with JSON in MySQL

November 17, 2015

MySQL 5.7 is GA and has over than 150 new features. One of them is a Native JSON Data Type and JSON Functions: “Allows for efficient and flexible storage, search and manipulation of schema-less data. Enhancements include a new internal binary format, support for easy integration within SQL, and index management on the JSON Documents using generated columns”.