Session
Programmatic Queries: things you can code with SQL

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

Programmatic Queries: things you can code with SQL

Download Slides

Speaker

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.

Sign-up to keep in touch and help us know our users

Your contact information is never shared outside of Percona. * denotes a required field.

Name: *

E-mail address: *

Company:

Phone number:

City, State/Province:

Country:

Do you use Percona software?

No Testing it Planning it Use in production

How did you discover Percona?

Friend Webinar Blog Conference Search Other

Subscribe me to Percona's email newsletter (sent every other month)

Have a Percona sales rep contact me about Support options

SessionProgrammatic Queries: things you can code with SQL