szkgroove Posted October 26, 2012 Share Posted October 26, 2012 Hello I have 2 MySQL databases on the same server with same structure and same data. Occasionally data in one database are changed for 7 days and then should be back to the same value as in first database. Through PhpMyAdmin I am trying to write statement that should do thi but something I am missing. I have databases: db1_local and db2_local Table gitem column gbaseprice (should be synchronized from db1 to db2) column gitemcode (has same value in both databases and synchronizing should be followed with this parameter so that id's don't mess up) Appreciate any help Here is statement e.g. SQL statement that run in db2 UPDATE gitem SET gbaseprice=db1_local.gbaseprice FROM db1_local.gitem(`gbaseprice`) INNER JOIN db1_local.gitemtable ON db1_local.gitem(`gitemcode`)=db2_local.gitem(`gitemcode`) Quote Link to comment https://forums.phpfreaks.com/topic/269934-update-table-from-one-database-with-data-from-another-database/ Share on other sites More sharing options...
Solution Barand Posted October 26, 2012 Solution Share Posted October 26, 2012 The syntax is UPDATE a INNER JOIN b ON ... SET a.x = b.y Quote Link to comment https://forums.phpfreaks.com/topic/269934-update-table-from-one-database-with-data-from-another-database/#findComment-1387975 Share on other sites More sharing options...
szkgroove Posted October 26, 2012 Author Share Posted October 26, 2012 you are right, it works fine thank you for effort Quote Link to comment https://forums.phpfreaks.com/topic/269934-update-table-from-one-database-with-data-from-another-database/#findComment-1388037 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.