Recursive Common Table Expressions in MySQL 8.0 (Part 1)

Tuesday 11:20AM-12:10PM

@ Goldsmith 1

MySQL / MariaDB

50 minutes conference



Starting with version 8.0.1, MySQL supports Common Table Expressions (CTEs), non-recursive and recursive. This talk will introduce these objects, demonstrate how they can be leveraged to create more readable queries, and produce some reports which would otherwise require writing some iterative or recursive stored procedures. Tree-traversal examples will be covered. The implementation will also be briefly discussed.

This is a double-length session: it runs from 11:20 to 13:10 in the same room.


Guilhem Bichot

Guilhem Bichot (Oracle)

Lead Software Engineer at Oracle


After some solid scientific studies, Guilhem has been working for 15 years as full-time C++ developer of the MySQL Server, from MySQL 4.0 to the most recent releases. These last years he's part of the Optimizer team.


  Download Slides  

Percona Live

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@)
  • +1-888-401-3401
  • +1-919-948-2863