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 free download?

633

What is difference between pdo and mysqli?

699

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

653

How can we convert between Unix & MySQL timestamps?

630

What is full text indexing in mysql?

681

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2146

What is timestamp in mysql?

718

Explain csv tables.

704

How do I know if mysql is running on windows?

672

What is default password for mysql?

655

How do I add a column to a table in mysql?

646

Which datatype is used for email in mysql?

691

What is the return type of mysqli_query?

624

What is the command line end user interface - mysql?

724

What is striped backup

1997