techker Posted August 27, 2010 Share Posted August 27, 2010 hey guys i need to compare 2 databases and see what is missing in one? whats in db1 missing in db2... how would this go about?with a search query? Quote Link to comment https://forums.phpfreaks.com/topic/211872-compare-2-db/ Share on other sites More sharing options...
techker Posted August 27, 2010 Author Share Posted August 27, 2010 i think i got it.. SELECT TbItemInventory. * FROM TbItemInventory LEFT JOIN xcart_products ON TbItemInventory.Name = xcart_products.productcode WHERE xcart_products.productcode IS NULL LIMIT 0 , 30 seems to be working good Quote Link to comment https://forums.phpfreaks.com/topic/211872-compare-2-db/#findComment-1104491 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.