How we can copy one table data into another table whose name
same as table but in differ database
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 tune a mysql query?
Is mongodb faster than mysql?
How is mysql database stored?
How do I delete a mysql user?
What is delimiter in mysql trigger?
How do I start mysql server?
What is trigger in mysql with example?
Can mysql function return a table?
What is join in mysql? What are the different types of join?
How do you restart mysql?
How can I see all mysql databases?
Does uninstalling mysql delete database?
Is sqlite faster than mysql?
Write a query to display even rows in student table using mysql?
Is mysql running ubuntu?