Programmatic Queries: things you can code with SQL

Clustrix Fusion-io Adfonic Continuent Facebook GenieDB Schooner Information Technology Severalnines SkySQL 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


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.



Shlomi Noach

Shlomi Noach


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


]]> ]]>