san2san Posted November 10, 2003 Share Posted November 10, 2003 How do I transfer particular records (say 10 records out of 100) which are updated in one database(say DB1, or DB2) to another one(say DBMain). The DBMain database contains data from DB1, DB2 and DB3. The rest of the data should not affected. I tried phpMyAdmin, but it does not solve my problems. Link to comment https://forums.phpfreaks.com/topic/1335-transferring-data-from-one-mysql-database-to-another/ Share on other sites More sharing options...
effigy Posted November 10, 2003 Share Posted November 10, 2003 insert into DBMAIN select * from DB1 where.... Link to comment https://forums.phpfreaks.com/topic/1335-transferring-data-from-one-mysql-database-to-another/#findComment-4428 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.