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
Explain triggers and stored procedures?
What is the current mysql version?
How does php communicate with mysql?
What is delimiter in mysql trigger?
How can I see all mysql databases?
How triggers can be used in mysql?
What are the functions in mysql?
How to get a list of all tables in a database?
Is mysql free for enterprise?
How we can get distinct columns values in mysql?
What do you understand by mysql terminal?
What is required to create mysql database?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
What are the different tables present in MySQL?
What is a mysql server?