Recursive Common Table Expressions in MySQL 8.0

Tuesday 12:20PM-1:10PM

@ Goldsmith 1

MySQL / MariaDB

50 minutes conference

Intermediate

Tracks:
Developer

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.


Speakers

Guilhem Bichot

Guilhem Bichot (Oracle)

Lead Software Engineer at Oracle

Biography:

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.


Percona Live

Percona Live Europe starts in:

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(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA