select * into databasename.<TableName> from (select * from database

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

Question Posted / payal

Answer Posted / payal

select * into databasename.<TableName> from (select * from
databasename.<TableName>)

Is This Answer Correct ?

10 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What is triggers and how it can be used in mysql?

962

can you tell how can you display the maximum salary in sql? : Mysql dba

856

What is the difference between mysql and pdo?

971

What is the difference between BLOB AND TEXT?

1139

What do ddl, dml, and dcl stand for?

904

How to delete a table.

920

Explain the difference between mysql and mysql interfaces in php?

1077

How to create a new table by selecting rows from another table in mysql?

981

What is the current mysql version?

1010

How to get a list of all tables in a database?

1045

Why do we use the mysql database server?

1038

How to create a new table in mysql?

1037

How many mysql connections can handle?

888

What is the difference between timestamp and datetime in mysql?

1040

How do I switch users in mysql?

959