Thread
: Tech
Comparing/Diff-ing MySQL Tables
View Single Post
04-05-2017, 01:16 PM
woj
<&(©¿©)&>
Industry Role:
Join Date: Jul 2002
Location: Chicago
Posts: 47,882
you don't need any "tool", just run a query using the 2 tables...
most straight forward way is probably to "LEFT JOIN" on id fields on the 2 tables and then search for "table2.id IS NULL" that will find any missing rows...
__________________
Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000
Affiliate program tools:
Hosted Galleries Manager
Banner Manager
Video Manager
Wordpress Affiliate Plugin
Pic/Movie of the Day
Fansign Generator
Zip Manager
woj
View Public Profile
Find More Posts by woj