select * into db1.db1_table from (select * from db2.db2

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

Question Posted / mahesh murali

Answer Posted / mahesh murali

select * into db1.db1_table from (select * from
db2.db2_table)

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Can you rename a database in mysql?

597

Is oracle mysql free?

552

What is the latest version of mysql?

581

What is a definer?

551

How do I restore a mysql database?

629

What is mysql and why it is used?

644

Can a table have multiple primary keys?

562

Where is mysql password stored?

552

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

574

What is a left join mysql?

558

How to display top 10 rows in mysql?

653

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

1639

What are the security alerts while using mysql?

644

What is the maximum no of columns a table can have?

551

How can we find out which auto increment was assigned on Last insert?

720