How we can copy one table data into another table whose name
same as table but in differ database
- 8 Answers
- 16194 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
How to create a table?
How can we run batch mode in mysql?
What are views in mysql?
What is maximum table size in mysql?
What is difference mysql and mysqli?
In which format data is stored in mysql database?
How many columns can a table have?
How do I backup mysql database on linux?
What is mysqli_free_result?
how to take mysql database backup?
What are the disadvantages of mysql?
Is primary key auto increment?
What are the difference between mongodb and mysql?
How do I start mysql from command line?
How to create a new table in mysql?
