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
- 17967 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
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
explain GROUPBY & HAVING clause with examples.
How do I edit a table in mysql?
List data types in mysql? Explain
What is timestamp in mysql?
How many columns can a mysql table have?
Can I install mysql on mac?
What is a select query?
How to use rank function in mysql?
What is localhost in mysql?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
How to print message in mysql trigger?
What is the insert?
Explain the storage engines in mysql?
What is mysql ndb?
