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
How triggers can be used in mysql?
Is oracle better than mysql?
Write a query to count the number of rows of a table in mysql.
What is append query?
What is the difference between truncate and delete?
What is the full form of mysql?
Can we rename database in mysql?
Difference between CHAR and VARCHAR?
How many groups of data types?
What is mysql enterprise edition?
What is current version of mysql?
What is schema in mysql?
What is flush privileges in mysql?
What is innodb_buffer_pool_size?
How database are managed?