How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 16685 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
Does mysql use t sql?
Is mysql still relevant?
What is limit in mysql?
What is mysql vs sql?
What is myisamchk?
How do I select a database in mysql?
What is mysql architecture?
What do you mean by % and _ in the LIKE statement?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
Define REGEXP?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
What are programming functions?
What is pragma exception?
Consider you have the following three tables which have to be linked together.
How to display top 10 rows in mysql?
