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
- 17855 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
Does adding an index lock a table?
Is mysql running ubuntu?
What is 'mysqlimport'?
How do I create a mysql username and password?
How do you create a primary key?
What are the steps required to view your mysql database?
Why do we use the mysql database server?
What is regexp?
How is oracle different from mysql?
What is mysql aggregate functions? Explain
How to get a list of indexes of an existing table?
What are the advantages/disadvantages of mysql and php?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
What is the maximum number of columns per table?
What is processlist in mysql?
