How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 16701 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 start mysql?
What is the datatype of image in mysql?
What is cast in mysql?
Write command to import an mysql file?
How to drop an existing index in mysql?
What is back end and front end?
Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?
What are the differences between binary and varbinary?
How to escape special characters in sql statements?
Can we store pdf files in mysql?
What can I do with mysql?
In which language mysql has been written?
What is the default port for MySQL Server?
How many rows we can insert in a mysql table?
How to enter boolean values in sql statements?
