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 is the latest version of php and mysql?

1268

What is auto increment in mysql?

1012

Which command is used to view the content of the table in mysql?

964

How can you retrieve a particular number of records from a table?

980

What are date and time data types?

1041

What is 'mysqldump'?

1118

What language is used in mysql?

1037

How do I flush privileges in mysql?

1059

What, if a table has one column defined as TIMESTAMP?

1074

How to get the current date in mysql?

1108

What is the use of procedure in mysql?

975

How can I see connections in mysql?

978

What is the insert?

943

What mysql -u john -p command does?

1025

Why to use char instead of varchar in the database?

1265