How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 16199 Views
- I also Faced
- E-Mail Answers
Answer Posted / bhas
CREATE TABLE `bhas`.`cds` ( table structure and data)
INSERT INTO `bhas`.`cds`
SELECT *
FROM `cdcol`.`cds` ;
where bhas is new db and cds is table name, cdcol is old db
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How do I exit mysql?
what is constraints?
How can you retrieve a particular number of records from a table?
What are the 3 main types of search queries?
What is regex in mysql?
What does do in mysql?
What is the difference between a heap table and temporary table?
What are the common mysql functions?
Is mongodb faster than mysql?
Can you tell few best practices to be followed for optimization in sql?
In which language mysql has been written?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
What is the difference between MyISAM Static and MyISAM Dynamic?
How can I see connections in mysql?
What is the difference between unix timestamp and mysql timestamp?
