Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

MySQL 8.0: CTEs

MySQL 8.0: CTEs

Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
Development
MySQL
Topics:
MySQL

Description

Common Table Expressions (sometimes referred to as WITH queries) are a new feature that will be available in MySQL 8.0. In their simplest form CTEs are a way of creating a view/temporary table for usage in a single query, and can help improve the readability of SQL code. They have many more use cases however, and particular when using the RECURSIVE form of CTEs it is possible to perform quite advanced tasks in few lines of code. This talk covers CTEs implementation in MySQL 8.0

Speakers

Guilhem Bichot's picture

Guilhem Bichot

Lead Software Engineer, Oracle

Biography:

Guilhem is working for more than 10 years as full-time C++ developer of the MySQL, from MySQL 4.0 to the most recent releases. He's part of the Optimizer team. Guilhem has a solid scientific academic background.

Share this talk