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

Answer Posted / payal

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

Is This Answer Correct ?    10 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between mysqli and pdo?

554


What do I do if I forgot my mysql root password?

546


What is a data directory?

598


How do I automate a backup in mysql?

551


What do you understand by mysql terminal?

598






How do I delete a row in mysql?

578


How do I create a mysql database?

577


Can I install mysql on mac?

600


How to see the create table statement of an existing table?

673


How database are managed?

628


How to Join tables on common columns.

717


What are ddl statements in mysql?

618


What is difference between mysql and mariadb?

583


How do I download mysql?

569


What is difference between unix timestamp and mysql timestamp?

612