~drizzle-trunk/drizzle/development

Viewing changes to docs/dynamic.rst

Make fixes to temporal docs
Make a few minor docs cleanups/fixes
Start using syntax-highlighting code blocks

added added

removed removed

Dynamic SQL allows you to execute DDL statements (and other SQL statements) that are not supported in purely static SQL programs.

In Drizzle you can use the EXECUTE command along with :doc:'user defined variables <variables>'

to create SQL in a dynamic manner on the server. An exmaple of this is: ::

to create SQL in a dynamic manner on the server. An exmaple of this is:

.. code-block:: mysql

SET @var= "SELECT 1";

EXECUTE @var;

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

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

.. code-block:: mysql

EXECUTE "SELECT 1";

generated and no data will be returned by the execution of the statement.

If you want to launch the query in a separate session, you can do that with

the following: ::

the following:

.. code-block:: mysql

EXECUTE "SELECT 1" CONCURRENT;