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
What is difference between mysqli and pdo?
What do I do if I forgot my mysql root password?
What is a data directory?
How do I automate a backup in mysql?
What do you understand by mysql terminal?
How do I delete a row in mysql?
How do I create a mysql database?
Can I install mysql on mac?
How to see the create table statement of an existing table?
How database are managed?
How to Join tables on common columns.
What are ddl statements in mysql?
What is difference between mysql and mariadb?
How do I download mysql?
What is difference between unix timestamp and mysql timestamp?