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 to present a past time in hours, minutes and seconds?

1051

How to filter data from a mysql database table with php?

905

What is mysql shell?

988

How to create a new view in mysql?

926

Is foreign key indexed mysql?

897

What is longblob?

985

What is the use of mysqli_fetch_array?

1049

What is insert query in mysql?

913

How do I delete a row in mysql?

973

How does limit work in mysql?

910

What are date and time intervals?

991

How do I import database through command line?

1011

How do you stop an access query?

916

How to rename an existing table in mysql?

1033

Why we use mysqli instead of mysql?

1091