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 will show all records containing the name "sonia" and the phone number '9876543210'
How do I update a variable in mysql?
What is ddl, dml, and dcl?
Is mysql free software?
What is blob storage?
How to enter boolean values in sql statements?
What are date and time intervals?
What is relational database in mysql?
What are slow queries?
can you tell what are the different set operations available in mysql? : Mysql dba
What is difference between schema and table?
What is the datatype of image in mysql?
How many columns can you create for an index?
What is use command in mysql?
can you tell the order of sql select statement? : Mysql dba