How we can copy one table data into another table whose name
same as table but in differ database
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 data node in mysql cluster?
How do I install mysql on windows 10 64 bit?
How can I create a database in mysql?
Is mysql running ubuntu?
What are mysql functions?
How do I connect to a mysql database?
How can you filter the duplicate data while retrieving records from the table?
What is the use of mysqli_fetch_assoc?
What data structure does mysql use?
What is mysql and how it works?
Does mysql scale well?
Can you tell which of the following where clauses is faster?
What is truncate in mysql?
Which datatype is used for email in mysql?
Explain about the architecture of MYSQL?