January 2019
Intermediate to advanced
286 pages
7h 41m
English
Content preview from Advanced MySQL 8
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Why is MySQL 8.0 the next generation?
As you can guess, MySQL 8.0 will be the next generation of databases because it will include the traditional side of SQL and NoSQL with JSON. The new features are not just those that I just mentioned; you will also find the following:
- Common table expression (CTE): A type of temporary table associated with a query that will allow you to use the WITH command for recursion.
- Invisible indexes: These are invisible to the MySQL optimizer; that is, they are maintained by the optimizer but not used by it. This has the big advantage of being able to test the behavior of the MySQL 8.0 server during evaluation and not the index.
- Oracle has also added to MySQL 8.0 what are called persisting configuration variables ...