CREATE TABLE `bhas`.`cds` ( table structure and data) INSERT INTO `bhas`

How we can copy one table data into another table whose name
same as table but in differ database

Question Posted / bhas

8 Answers
17853 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

Please Help Members By Posting Answers For Below Questions

How will show all records containing the name "sonia" and the phone number '9876543210'

887

How do I update a variable in mysql?

918

What is ddl, dml, and dcl?

968

Is mysql free software?

946

What is blob storage?

962

How to enter boolean values in sql statements?

1112

What are date and time intervals?

968

What is relational database in mysql?

909

What are slow queries?

890

can you tell what are the different set operations available in mysql? : Mysql dba

871

What is difference between schema and table?

899

What is the datatype of image in mysql?

903

How many columns can you create for an index?

942

What is use command in mysql?

1020

can you tell the order of sql select statement? : Mysql dba

892