Interested to Buy Any Domain ? << Click Here >> for more details...
How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 17966 Views
- I also Faced
- E-Mail Answers
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
What are slow queries?
What sql does mysql use?
What are views in mysql?
How can you filter the duplicate data while retrieving records from the table?
What is the purpose of using ifnull() function?
using primary can we relate two table, with out foreign key?
How to insert dynamic values in mysql using php?
How do I kill a mysql query?
Do while loop in mysql procedure?
How do I install mysql on windows 7?
What is the difference between the primary and unique key in mysql?
What is the difference between heap table and temporary table?
What is longblob?
What are the advantages of mysql?
Where MyISAM table will be stored and also give their formats of storage?
