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

Explain the difference between procedure and function in mysql?

976

How many columns is too many mysql?

882

How do I copy a table in mysql?

920

Does mysql support sequence?

922

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

899

What is mysql community server?

917

In mysql, what is the default storage engine?

985

What is the limit of mysql database?

942

Is mysql same as sql?

876

What is meant by sharding?

911

When to use order by in delete statement?

1007

How do we use % when performing a search query?

903

Where is mysql data stored?

869

How to get help information from the server?

1030

How do you select a table?

929