Re: Comapring Tables

[Paul Svirin]

Here is the comparation for mysql.user table:

select
case when exists (select user from user where user not in (select user from user) ) then 1
else 0
end as result;


Was that helpful?

---------------------
StarWind Software developer (http://www.starwindsoftware.com)