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

What data structure does mysql use?

942

How do I install and use mysql?

881

How do I declare a variable in mysql?

869

Explain csv tables.

932

What is mysqlcheck do?

958

What is “i_am_a_dump” flag in mysql?

990

What is append query?

860

What is meant by mysqli?

840

What is the difference between MyISAM Static and MyISAM Dynamic?

1000

Explain the difference between primary key and candidate key in mysql?

904

What does mysql workbench do?

808

What are the method you will follow while sql installing

2311

What are the functions of commit and rollback statements?

941

How many ways to get the current time?

916

What is the default port number of mysql?

888