How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 15714 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 to delete a database from mysql server.
What is the command line end user interface - mysql?
How do I select a table in mysql?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
Can you tell what are various ways to create an index?
How do I download mysql on my laptop?
What are the technical specifications of mysql?
Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?
How to returns the columns and column information pertaining to the designated table.
What is a delimiter in mysql?
How to change a password for an existing user via mysqladmin?
How do I add a column to a table in mysql?
How do I find the size of a mysql database?
How does limit work in mysql?
What is mysqlcheck do?
