Re: group by help?

You're right, it wasn't the answer I wanted to hear ;-) But it has a ring of truth to it. Thanks for all your help Mick Paul DuBois wrote: At 13:34 +0100 4/19/02, Mick Watson wrote: Thank you :-) I do realise the SQL is not being used as it should be, but as it is not my database

Re: GUI for mySQL

I have to concur, MS Access with ODBC linked tables is not a good solution when those tables contain large amounts of data. I had queries run for hours and then come up with a simple ODBC Failed message at the end of it. Maybe Access has improved though. Tod Harter wrote: Watch out with

group by help?

Hi I am having some trouble figuring out how mySQL interprets the group by clause in a particular set of data that I have (the ensembl database if anyone is familar with it!) Now, I have some data like this: +-++--+ | gene_id | display_id | db_name |

Re: group by help?

, not mysql. hope this helps... - Original Message - From: Mick Watson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 19, 2002 6:01 AM Subject: group by help? Hi I am having some trouble figuring out how mySQL interprets the group by clause in a particular set of data

Re: group by help?

the internal machinations of mysql, I can only suggest that you study the source code. - Original Message - From: Mick Watson [EMAIL PROTECTED] To: Richard Emery [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, April 19, 2002 7:34 AM Subject: Re: group by help? Thank you :-) I