Interested to Buy Any Domain ? << Click Here >> for more details...
How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 18169 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 run 'mysql' commands from a batch file?
How to display odd rows in student table in mysql?
What are different types of queries?
What is logs in mysql?
What are the three types of queries?
How do I remove a user from mysql?
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
What is mysql used for?
Where is mysql data stored?
How can you calculate the sum of any column of a table?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
How to find the unique values if the value in the column is repeated?
How does mysql store dates?
What are all the Common SQL Function?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
