Recursive Query Throwdown in MySQL 8 - Bill Karwin - MySQL Tutorial

Bill Karwin (SchoolMessenger) delivers his talk, "Recursive Query Throwdown in MySQL 8", on DAY 3 of the Percona Live Open Source Database Conference 2017, 4/27, at Santa Clara, CA.
Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔
#MySQL 8 introduces support for #AnsiSQL recursive queries with common table expressions, a powerful method for working with recursive data references. Until now, MySQL application developers have had to use workarounds for hierarchical data relationships. It's time to write SQL queries in a more standardized way, and be compatible with other brands of SQL implementations. But as always, the bottom line is: how does it perform? This presentation will briefly describe how to use recursive queries, and then test the performance and scalability of those queries against other solutions for hierarchical queries.
📺Subscribe To Our Channel + Turn on the 🔔 and Get More information about #OpenSource #Databases, #kubernetes and many other things.
percona.tv/subscribe
You can find more about #OpenSource #Databases and Percona Live Online 2020 in these links 👇🏻👇🏻👇🏻
per.co.na/Q8eykw
per.co.na/lGkGc9
per.co.na/pl2020
Connect With us on our Social Networks 👇🏻👇🏻👇🏻
Follow Percona on Twitter: per.co.na/twitter
Follow Percona on Facebook: per.co.na/facebook
Follow Percona on Instagram: per.co.na/instagram
Follow Percona on LinkedIn: per.co.na/linkedin

[@kreaweb-be]

Excellent explanation. Thanks.

[@thanasisathanasi4965]

Man, you saved my day. Wonderful and straightforward tutorial. Really saved me a lot of days of trying to figure out. Thanks so much. I am watching now !!!!

[@tjalferes]

Bill Karwin and Markus Winand are two of the best SQL and MySQL authors I've found so far!

[@pollafattah7062]

For some reason I hated the double recursion only to have the right order of depth because it can be solved by easily by the conumming application. As it gave the impression of beating slow.

[@abdulrahman19_]

Thanks so much for such amazing video.

[@lucasloffel437]

Thank you for this vid!

[@mehhhdiiiiiiiiii]

This video saved my project !

[@thanasisathanasi4965]

Man. This is what just happened with me now !!! It has saved my project too !!!

[@jimmysyar889]

is the source code for the python demo anywhere?