How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 16678 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 table level locking in mysql?
Is there a free version of mysql?
How do you connect MySQL database with PHP?
How do I select a database in mysql workbench?
What is the date format in mysql?
What is datatype in mysql?
How can you calculate the sum of any column of a table?
What is a result set object?
What is mysql url?
Is mysql good for large database?
Is foreign key indexed mysql?
What are views in mysql?
Can you tell which of the following where clauses is faster?
How do I run a query in mysql?
How do I create a schema in mysql?
