Norvald Ryeng (Oracle) delivers the talk, "LATERAL Derived Tables in MySQL 8.0", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

Since version 8.0.14, MySQL supports LATERAL derived tables, sometimes called the for each loop of SQL. What are they? How do they work? Why do you need them? What can they do? How can you use them? Should you use them? What is all this talk about for each loops?

In this session we'll explain the concepts, look at examples of how and when to use this new feature, and talk about how LATERAL derived tables are optimized and executed by MySQL.

Related Videos: Percona Live Sessions, MySQL

Optimize and Troubleshoot MySQL using PMM
Using PMM to Identify and Troubleshoot Problematic MySQL Queries
Google Cloud Platform: MySQL at Scale with Reliable HA
Analytical Queries in MySQL - PLO October 2020
MySQL Ecosystem on ARM - Krunal Bauskar - Percona Live ONLINE 2020
How Does Geo-Replication Work in TiDB? - Jay Lee - Percona Live ONLINE
SQL Row Store vs Data Warehouse: Which Is Right for Your Application? - Robert Hodges - PLO October 2020