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.
Thread beginning with comment 483145
To view parent comment, click here.
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"
benali72
Member since:
2008-05-03

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

RE[2]: advice needed
by fran on Tue 2nd Aug 2011 11:52 in reply to "RE: advice needed"
fran Member since:
2010-08-06

thx for this.
Will try.

Reply Parent Score: 2

RE[3]: advice needed
by dacresni on Tue 2nd Aug 2011 15:44 in reply to "RE[2]: advice needed"
dacresni Member since:
2009-08-26

you should also revise your understanding of what a relational database is. It should never cross your mind to export the data out of the database to compare or do any analysis. I wouldn't do complex statistical models inside it but most analysis like means and modes, compares any set operations should be done with SQL or what ever database interface your using (unsql, gql orm, pg/*, whatever)

Reply Parent Score: 1