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

Answer Posted / mahesh murali

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

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How triggers can be used in mysql?

540


Is oracle better than mysql?

452


Write a query to count the number of rows of a table in mysql.

455


What is append query?

491


What is the difference between truncate and delete?

581






What is the full form of mysql?

494


Can we rename database in mysql?

474


Difference between CHAR and VARCHAR?

564


How many groups of data types?

494


What is mysql enterprise edition?

435


What is current version of mysql?

434


What is schema in mysql?

475


What is flush privileges in mysql?

506


What is innodb_buffer_pool_size?

449


How database are managed?

532