Linked by snydeq on Mon 1st Aug 2011 14:30 UTC
Databases MySQL toolmaker Daniel Nichter provides a look at 10 must-have free and open source tools for MySQL. 'MySQL has attracted a vibrant community of developers who are putting out high-quality open source tools to help with the complexity, performance, and health of MySQL systems, most of which are available for free,' writes Nichter, who was named 2010 MySQL Community Member of the Year for his work on maatkit. From mydumper, to mk-query-digest, to stalk and collect, the list compiles tools to help back up MySQL data, increase performance, guard against data drift, and log pertinent troubleshooting data when problems arise, each of which is a valuable resource for anyone using MySQL, from a stand-alone instance to a multiple-node environment.
Permalink for comment 483145
To read all comments associated with this story, please click here.
RE: advice needed
by benali72 on Tue 2nd Aug 2011 09:47 UTC in reply to "advice needed"
Member since:

I'm not sure I understand your question. If your goal is to compare the data in two MySQL tables, you do not need to load the data into Excel first. Just google on "how to compare MySQL tables" and you'll find many example SQL statements to do this.

Here's one approach --

select * from table a where a.common not in (select b.common from table b where a.common = b.common)

then switch up the tables in the query and you can check each table.

Reply Parent Score: 1