How to create dynamic table in mySql

Question

I want to know how to create dynamic table in mySql . I have used dynamic table in Sqlserver 2008 but i am new to mySql . Is it possible ?

Eg: In Sql server i have created Dynamic Customer Table.

DECLARE @tblCustomer as table(
            [ ] bit
            ,Sl#        int
            ,custID     int
            ,CustCode   varchar(max)
            ,Customer   nvarchar(max)
            ,Authorized bit
            ,RCount     int)

  SELECT * FROM @tblCustomer

Please Help

steven7mwesigwa · Accepted Answer · 2022-09-10 22:57:14Z

2

@sqlstmt = 'whatever sql';
Prepare st from @sqlstmt;
Execute @st;
Deallocate prepare @st;

Place the CREATE TABLE statement in @sqlstmt and you are good to go !

The table is a real one. You would have to drop the table afterwards.

edited Sep 10, 2022 at 22:57

steven7mwesigwa

6,8783 gold badges27 silver badges40 bronze badges

answered May 19, 2011 at 11:51

RolandoMySQLDBA

44.4k16 gold badges96 silver badges136 bronze badges

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

Comments

John Green · Accepted Answer · 2011-05-19 11:47:20Z

1

Pretty easy to do:

 CREATE TABLE AS
 SELECT * FROM tblCustomer

It will take the existing field types from the schema where possible..

answered May 19, 2011 at 11:47

John Green

13.5k3 gold badges31 silver badges52 bronze badges

2 Comments

Biju Kalanjoor Over a year ago

how can we create a new table with diffrent name from the tblCustomer?

John Green Over a year ago

Just give it the name, like this: CREATE TABLE companies_test AS SELECT * FROM companies @BijuKalanjoor

Collectives™ on Stack Overflow

How to create dynamic table in mySql

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related