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 difference between unix timestamp and mysql timestamp?

1011

What is the role of a limit in a mysql query?

1005

How do I exit mysql?

914

What is insert query in mysql?

906

How can we encrypt and decrypt a data presented in a table using mysql?

1057

What are the technical features of MySQL?

1011

Can you tell a way to know the number of days between the two given dates in php?

1093

How to include numeric values in sql statements?

1013

How do I remove a user from mysql?

988

How many entries can mysql handle?

1009

what is the difference between gui testing and database testing? : Mysql dba

1095

How to store binary data in mysql?

1000

What is difference between mysqli and pdo?

934

What is mysql sleep process?

1031

Is mysql a framework?

922