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 to create table show example
What is 'mysqld'?
What does tinyint mean?
Can foreign key have duplicate values?
How to Join tables on common columns.
What is ntext?
What is database url for mysql?
What is mysql server used for?
Write a query to retrieve a hundred books starting from 20th.
Is mysql open source?
How do I setup mysql?
How do I use mysql?
What is 'mysqldump'?
What is blob and text in mysql?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.