create table tablename select * from databasename.tablename i'm exp

How we can copy one table data into another table whose name
same as table but in differ database

Question Posted / jayanthi reddy

Answer Posted / jayanthi reddy

create table tablename select * from databasename.tablename

i'm expecting this will work. if anything wrong correct it

Is This Answer Correct ?

8 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What can you do with mysql?

1013

How we can get distinct columns values in mysql?

1086

What is foreign key in mysql?

1038

How do I show columns in mysql?

935

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

1074

How do I disconnect mysql workbench?

1068

Is foreign key indexed mysql?

897

What is normalization and list the different types of normalization?

952

How can I see mysql database?

911

How can we change the data type of a column of a table?

1001

How do I run mysql?

1014

What is bdb (berkeleydb)?

947

If you wish to encrypt the username and password using php, how will you do that?

1022

What is a result set object?

958

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

992