Mysql Create Table with dynamic database name

Question

I am creating database at runtime and I want to create the tables in that database at the same time. Can anyone give me any thought on how to do that? For Example -

I have created one database named 'mydb' and now in the same process I am trying to create the table I am using the mysql stored procedure for the same. My proc input will be my dbname. So, my proc looks like

create procedure test(IN dbname varchar(100))
begin 
    create table `dbname`.`testing`(testid int, testname varchar(45));
end

Cade Roux · Accepted Answer · 2009-05-30 07:34:27Z

2

You can use the PREPARE feature to execute dynamic SQL.

answered May 30, 2009 at 7:34

Cade Roux

90.1k42 gold badges186 silver badges268 bronze badges

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

Collectives™ on Stack Overflow

Mysql Create Table with dynamic database name

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related