Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

How to create dynamic table in mySql

⇧
0
⇩
43 views

Hai all,

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

mysql dynamic-tables
asked May 19, 2011 6:40 am CDT
Vyas
posted via StackOverflow

2 Answers

⇧
0
⇩
 

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 7:23 am CDT
John Green - PageSpike
⇧
0
⇩
 
 
@sqlstmt = 'whatever sql';
Prepare st from @stlstmt;
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.

answered May 19, 2011 7:23 am CDT
RolandoMySQLDBA

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
How do I create a domain with a dynamic A NAME Record/dynamic IP Resolution?
March 7, 2011
Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?
January 10, 2011
Dynamic List: Static Table or Div height and width, Dynamic number of columns
January 21, 2011
Php dynamic table with dynamic combo box's in each row
January 21, 2011
Mysql dynamic table standard
March 2, 2011
Mysql dynamic table or view
March 10, 2011
Create temporary table from select statement without using Create Table
May 2, 2011
Add a dynamic field to a MySQL table based on a functions value.
January 17, 2011
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
Mysql create table based on another table including indexes
January 25, 2011
Create a enum table and access it from other table in mysql
March 21, 2011
MySQL create table containing values from a column in another table.
January 28, 2011
How to create a "dynamic" forms - and store data and form design in two fields.
February 9, 2011
MySQL create table
April 13, 2011
Create table mysql
April 15, 2011
Create table - Mysql
May 16, 2011
MySQL - Aren't these privileges enough to create a table?
January 3, 2011
Can't create foreign key on mysql table
March 23, 2011
How to create index in two table mysql?
January 13, 2011
Convert Simple T-SQL DDL to MySQL DDL (Create Table)
January 6, 2011
Mysql create a table character sets
January 25, 2011
MySQL table create taking way too long
February 11, 2011
Mysql how to create optimum query for these table
February 11, 2011
How to create mysql table with many hasMany association in CakePHP?
January 18, 2011
MySQL Create Tables Based On Values From A Different Table
May 4, 2011
Mysql Create Table Error?? Version prolems maybe??
April 14, 2011
Mysql proxy to check create table statement
February 22, 2011
Is there a mysql equivalent of show create table in postgres???
February 6, 2011
MySql errno: 150 Create table statement inside
May 6, 2011
Help to creating a formula on mysql to create another column on another table
March 6, 2011