How to use String variable value in 'create table' statement? [duplicate]

Question

I have this stored procedure in which i create new tables with the table_name being a variable. but though

select table_name;

returns variable value

create table table_name(some_columns);

creates a table with name table_name and not the value.

Weird is that this posting is marked duplicate by you only after you answered it. — Ravinder Reddy
– Ravinder Reddy, Commented Jun 26, 2014 at 6:54

Barmar · Accepted Answer · 2014-06-26 05:35:21Z

2

You need to execute a prepared statement:

SET @sql = CONCAT('CREATE TABLE ', table_name, ' (some_columns);';
PREPARE stmt FROM @sql;
EXECUTE stmt;

answered Jun 26, 2014 at 5:35

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you. Btw the ';' inside is redundant.