Showing entries 1 to 2
Displaying posts with tag: generated column (reset)
May
14
2019
CHECK constraints in MySQL
Posted by Olivier Dasini on Tue 14 May 2019 08:05 UTC
Tags:

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.

Nov
17
2015
30 mins with JSON in MySQL
Posted by Olivier Dasini on Tue 17 Nov 2015 15:21 UTC
Tags:

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".

Showing entries 1 to 2