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 current version of mysql?

1085

How to Change a users password from unix shell.

1223

What is the current mysql version?

1105

Which statement is used in a select query for partial matching?

1247