dynamical tablenames

Hi all!

I am about to create a procedure which will create tables with
dynamically specified tablenames.

Something like this

DECLARE tname CHAR(30);
SET tname = "1233321"; #or any string function
CREATE TABLE tname
(
#columns cpecification
);


But it doesn't works....

Hi Ilya

You are not allowed to do this! If you can use temporary tables instead then
that would be a better solution. Failing that, read the following article
carefully http://www.sommarskog.se/dynamic_sql.html

John


"Ilya Dyoshin" wrote:

> Hi all!
>
> I am about to create a procedure which will create tables with
> dynamically specified tablenames.
>
> Something like this
>
> DECLARE tname CHAR(30);
> SET tname = "1233321"; #or any string function
> CREATE TABLE tname
> (
>      #columns cpecification
> );
>
>
> But it doesn't works....
>