select * into databasename.<TableName> from (select * from database

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

Question Posted / payal

Answer Posted / payal

select * into databasename.<TableName> from (select * from
databasename.<TableName>)

Is This Answer Correct ?

10 Yes

10 No

Please Help Members By Posting Answers For Below Questions

What are different types of queries?

947

What is the difference between BLOB AND TEXT?

1150

How to show certain selected rows with the value "pcds".

928

How to get nth highest salary from table in a mysql?

955

What is the command line end user interface - mysql?

1083

Can I use mysql for free?

905

What is mysql and how it works?

981

How can you import tables from a sql file into a database by using the mysql client?

1036

How to get the number of rows selected or affected by a sql statement?

921

What do you understand by mysql terminal?

1048

Why MySQL is used?

1033

How do I update a variable in mysql?

939

Does insert statement lock the table?

948

What is deterministic in mysql?

980

How to use 'mysql' to run sql statements?

1095