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
- 18171 Views
- I also Faced
- E-Mail Answers
Answer Posted / guru
INSERT INTO database2.table_name (column_name)
SELECT table_name.column_name FROM table_name
If two databases are in same server, this code will work.
For more details visit,
http://www.phponwebsites.com/2013/12/Copy-values-from-one-database-to-another-in-mysql.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is mysql connector used for?
What are the objects can be created using CREATE statement?
What is the difference between procedure and function in mysql?
What does mysql flush tables do?
What is mysql protocol?
Is mysql a server?
How do I install mysql on windows 10?
How do you select a table?
What is trigger in mysql with example?
How do I kill a mysql query?
Is pdo more secure than mysqli?
How to install mysql?
How do I disable mysql?
Why we use mysql database?
How to display top 50 rows?
