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

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

931

What is data type for image in mysql?

858

How would concatenate strings in mysql?

1021

Is mysql relational database?

895

How many rows can mysql hold?

879

Is mariadb better than mysql?

1035

What you can use regular expression for in mysql? Support your answer with an example?

888

What are the disadvantages of stored procedures?

972

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1113

What is a query in mysql?

981

How can I see mysql database?

897

What is datatype in mysql?

937

What is federated tables in mysql?

902

How do I optimize a selected query in mysql?

922

How do I delete a row in mysql?

948