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
- 18175 Views
- I also Faced
- E-Mail Answers
Answer Posted / bhas
CREATE TABLE `bhas`.`cds` ( table structure and data)
INSERT INTO `bhas`.`cds`
SELECT *
FROM `cdcol`.`cds` ;
where bhas is new db and cds is table name, cdcol is old db
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Write command to import an mysql file?
What is difference mysql and mysqli?
How do I remove a user from mysql?
How can you find out the version of the installed mysql?
How do you create a primary key?
Why mysql is used with php?
Explain the different types of constraints?
What is the limitation of mysql?
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
How do I start and stop mysql server?
How to check if a record exists in a mysql database php?
What you can use regular expression for in mysql?
In which language mysql has been written?
What is triggers?
How do I stop a query in mysql workbench?
