Session
Programmatic Queries: things you can code with SQL

Sponsors
Clustrix Fusion-io Adfonic Continuent Facebook GenieDB Schooner Information Technology Severalnines SkySQL Booking.com Scalebase Couchbase FromDual Monty Program Sphinx Tokutek Devart Ivinco Virident Webyog Drizzle Apress New York PHP O'Reilly PalominoDB Stackware

October 25th, 4:00 PM
Ludgate Suite

Abstract

SQL is not as declarative language as sometimes implied. There are programmatic aspects even to standard queries. This is even more true in MySQL, where one can expect a certain behavior on query execution. In this session we will observe some of this behavior and how to use it to create queries of programmatic nature. We will see how to take advantage of row evaluation order, control flow behavior, table & query inference order, and time evaluation and suspension.

Slides

Speaker

Shlomi Noach

Shlomi Noach

Consultant, openark.org

Shlomi is a software developer, a MySQL DBA, consultant & instructor. He authors the openark-kit and mycheckpoint open source tools, and blogs at openark.org. He is the 2009 MySQL Community Member of the Year.

 

]]> ]]>