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

October 3-5, 2016

Amsterdam, Netherlands

MySQL 8.0: Common Table Expressions

MySQL 8.0: Common Table Expressions

 4 October 5:20 PM - 6:10 PM @ Zürich 1
Experience level: 
Beginner
Duration: 
50 minutes conference
Tracks:
MySQL
Topics:
MySQL
Fundamentals

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, in particular when using the RECURSIVE form of CTEs it is possible to perform advanced tasks with few lines of code. This session covers CTEs implementation in MySQL 8.0.

Speakers

Øystein Grøvlen's picture

Øystein Grøvlen

Senior Principal Software Engineer, Oracle

Biography:

Øystein Grøvlen is a Senior Principal Software Engineer in the MySQL group at Oracle, where he works on the MySQL Query Optimizer. Dr. Grøvlen has a PhD in Computer Science from the Norwegian University of Science and Technology. Before joining the MySQL team 9 years ago, he was a contributor on the Apache Derby project and Sun's Architectural Lead on Java DB. Prior to that, he worked for 10 years on the development of Clustra, a highly available DBMS. Øystein lives in Trondheim, Norway.

Share this talk


Slides