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
- 17897 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
What is difference between unix timestamp and mysql timestamp?
What does it mean to be case sensitive?
How to delete an existing column in a table?
What is the usage of regular expressions in mysql?
What is heap table?
What is inner join in mysql?
How do I know if mysql is installed on windows?
What is bigint in mysql?
How do I edit a database in mysql workbench?
Where the database is stored in mysql?
Is mysql server free?
How can you find out the version of the installed mysql?
How to check if value already exists in mysql database in php?
How to make a column bigger and delete unique from table.
What is the storage engine for mysql?
