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

Is mysql query case sensitive?

950

What is the limitation of mysql?

947

How do I declare a variable in mysql?

915

Is mysql case-sensitive?

874

What does mysqli_fetch_assoc do?

891

What is meant by mysqli?

884

What port is mysql running on?

916

What are the common mysql functions?

926

What are aggregate functions in mysql?

1345

Why mysql is used with php?

952

What is the use of mysqli_fetch_assoc?

892

How we can get distinct columns values in mysql?

1057

How to define numeric 9(3) in db2 table without decimal point??

2835

What language is used in mysql?

980

What is a longblob?

929