How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 16197 Views
- I also Faced
- E-Mail Answers
Answer Posted / jayanthi reddy
create table tablename select * from databasename.tablename
i'm expecting this will work. if anything wrong correct it
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
How can I see all mysql databases?
How to create trigger in mysql phpmyadmin?
How you will show all data from a table.
How do I rename a table in mysql workbench?
What is root password?
What is current version of mysql?
How to get current MySQL version?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
Can we store pdf files in mysql?
How we can see all indexes defined for a table in mysql?
What is the difference between heap table and temporary table?
What is unsigned in mysql?
Is mongodb faster than mysql?
What is flush privileges in mysql?
How do I rename a procedure?
