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. Quote 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.... Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.