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? 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 Link to comment https://forums.phpfreaks.com/topic/211872-compare-2-db/#findComment-1104491 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.