how to duplicate table?

[zgkhoo]

how to duplicate table?

eg now i got one table name "testing123" and i wanna another copy of this table and using different name .."testing456"...how to do that?

thanks in advance.

[btherl]

If you just want to copy the data, you can use

 

CREATE TABLE foo SELECT * FROM bar

 

If you want an exact copy including indexes and so on, I can't help you there.

[fenway]

If you just want to copy the data, you can use

 

CREATE TABLE foo SELECT * FROM bar

 

If you want an exact copy including indexes and so on, I can't help you there.

Actually there's a "create table like" option to get the structure... and then you can simply insert into... select where 1=1.

[zgkhoo]

how to copy the structure and also the data too?

use SELECT INTO or?

thanks

[trq]

Read the replies above.

[zgkhoo]

If you just want to copy the data, you can use

 

CREATE TABLE foo SELECT * FROM bar

 

If you want an exact copy including indexes and so on, I can't help you there.

 

wat is meant by indexes? thanks

[fenway]

If you just want to copy the data, you can use

 

CREATE TABLE foo SELECT * FROM bar

 

If you want an exact copy including indexes and so on, I can't help you there.

 

wat is meant by indexes? thanks

Seriously? Then read all the stickies first before posting anything else or ever working on a database.

[zgkhoo]

If you just want to copy the data, you can use

 

CREATE TABLE foo SELECT * FROM bar

 

If you want an exact copy including indexes and so on, I can't help you there.

 

how to show the progress bar? eg 1% to 100% ?

 

[zgkhoo]

$sql = "CREATE TABLE $new_table SELECT * FROM template";

it wont set the primary key in the duplicate table ......how to solve it? set it manually ?

thanks?

[zgkhoo]

and it also wont copy the engine....still myisam engine  :-\

[fenway]

If you just want to copy the data, you can use

 

CREATE TABLE foo SELECT * FROM bar

 

If you want an exact copy including indexes and so on, I can't help you there.

 

how to show the progress bar? eg 1% to 100% ?

 

Progress bar in mysql?

 

$sql = "CREATE TABLE $new_table SELECT * FROM template";

it wont set the primary key in the duplicate table ......how to solve it? set it manually ?

thanks?

I didn't realize that was possible, to make a new table and copy the data in one step....

 

and it also wont copy the engine....still myisam engine  :-\

Since I don't know that original table looks like, it's hard to guess.

[zgkhoo]

$sql = "CREATE TABLE pyrmain


		(
		PID integer(10),
		Serialnum varchar(10),
		UplineSerial varchar(10),
		UplinePID integer(10),
		Downleft integer(10),
		LeftSerial varchar(10),
		Downright integer(10),
		RightSerial varchar(10),
		RowNum integer(10),
		ColumnPosi integer(10),
		ColumnTotal integer(10),
		DownlineAmount integer(10),
		Initial varchar(10),
		ActivateTime datetime,
		Status varchar(10),
		UserID varchar(10),
		ExpiredDate datetime,
		CreateDate datetime,
		Golden varchar(10),

		Primary Key (PID)    	    
		)engine=innodb";

 

how to duplicate the primary key and the engine  as well?

thanks

[btherl]

I don't know if this helps for what you want to do, but "SHOW CREATE TABLE tablename" will give you the command to create a table.  Then you can just edit the name and execute that command.

[zgkhoo]

mysql_query("ALTER TABLE $new_table ADD Primary Key (PID)");

can this work?

[fenway]

I don't know if this helps for what you want to do, but "SHOW CREATE TABLE tablename" will give you the command to create a table.  Then you can just edit the name and execute that command.

There's a CREATE TABLE LIKE command.