I gave a thirty minute talk at Drupalcon this week on the
features in MySQL 8.0 that would be of interest to developers and
for such a short talk (and I cut slides to allow for audience
questions) I could only cover the highlights. One attendee gently
chastised me over no including their favorite new MySQL 8.0
feature -- functional indexes.
What is a Functional Index?
The manual says MySQL 8.0.13 and higher
supports functional key parts that index expression values rather
than column or column prefix values. Use of functional key parts
enables indexing of values not stored directly in the
table.
There are some cool examples in the documentation on setting up
some functional indexes, as can seen below.
CREATE TABLE t1 (
col1 INT, col2 …
Showing entries 1 to 1
Apr
13
2019
Showing entries 1 to 1