SELECT * INTO table_name [IN externaldatabase] FROM tablename

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

Question Posted / jyoti

Answer Posted / jyoti

SELECT *
INTO table_name [IN externaldatabase]
FROM tablename

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do you select a table?

927

Can python connect to mysql?

987

What is the difference between the primary and unique key in mysql?

967

What is mysql connector used for?

918

Can foreign key have duplicate values?

877

How do I delete a table in mysql workbench?

1017

What is mysqladmin flush hosts?

938

Can not connect to mysql server 10060?

899

explain GROUPBY & HAVING clause with examples.

2274

What tools available for managing mysql server?

1002

What can I do with mysql?

898

What is database migration in mysql?

999

Is mysql owned by oracle?

994

How many rows can a mysql table hold?

993

What is view in mysql?

961