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
- 17655 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 to include character strings in sql statements?
How do I install mysql?
Do I need python for mysql?
What is inner join in mysql?
How can we get the number of rows affected by query?
what is the default port for mysql server? : Mysql dba
What is tee command in mysql?
What are the different column comparison operators in mysql?
Where MyISAM table will be stored and also give their formats of storage?
Is microsoft sql same as mysql?
What is table level locking in mysql?
How to get a version of mysql?
how to connect a php script with the mysql database?
What is row locking in mysql?
How to increment dates by 1 in mysql?
