~drizzle-trunk/drizzle/development

1
2
3
4
5
6
7
8
9
10
11
12
Dynamic SQL
========

In Drizzle you can use the EXECUTE command along with user defined variables
to create SQL in a dynamic manner on the server. An exmaple of this is:

SET @var= "SELECT 1";
EXECUTE @var;

You can also omit the variable and just insert the SQL directly:

EXECUTE "SELECT 1";