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 to display odd rows in student table in mysql?

927

Is mysql free software?

904

How do I install mysql on windows 7?

938

Are stored procedures precompiled?

918

How do I insert multiple rows in a table?

843

What's the difference between mysql and sql server?

925

What is pdo mysql?

880

Explain the storage engines in mysql?

950

What is meant by mysqli?

841

Can you tell few best practices to be followed for optimization in sql?

856

What is logs in mysql?

822

What does mysql flush tables do?

906

What are all the Common SQL Function?

1050

What is a result set object?

901

How do you know the version of your mysql server?

1094