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

How internally data stores in MyISAM and INNODB table types?

2684

What is definer in mysql?

941

Is foreign key indexed mysql?

875

What do ddl, dml, and dcl stand for?

886

How do I update a variable in mysql?

919

Can we join 3 tables in mysql?

931

What is the purpose of using a heap table?

1093

How to delete an existing column in a table?

922

How to run 'mysql' commands from a batch file?

1030

How can you filter the duplicate data while retrieving records from the table?

881

How many rows we can insert in a mysql table?

940

How do I edit a database in mysql workbench?

897

What is mysqladmin flush hosts?

938

How do I change a procedure in mysql?

982

What is use of mysql?

916