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 I find mysql database?

857

What is the usage of "i-am-a-dummy" flag in mysql?

1067

What are views in mysql?

872

What is a longblob?

889

Why we use mongodb instead of mysql?

922

What is bigint in mysql?

865

How to calculate expressions with sql statements?

1022

Is mysql free software?

904

How do I export mysql query results to excel?

916

What do you understand by mysql terminal?

984

What is the full meaning of mysql?

911

What is mysql_query?

794

How do I start mysql in linux?

839

Explain the difference between delete and truncate.

934

If we use sum function in mysql, does it return sum of that row or for that column?

933