Re: Can't get expected SELECT GROUP BY results

2008-12-26 Thread Fish Kungfu
Thank you, Peter! I'll give that a try. ~~Fish~~ On Fri, Dec 26, 2008 at 2:33 PM, Peter Brawley wrote: > Sorry LOL, make that http://www.artfulsoftware.com/infotree/queries.php. > > PB > > - > > > Peter Brawley wrote: > > What I want to do is SELECT only the most recent dateTime and critte

Re: What files to install for Windows

2008-12-26 Thread Menachem Bazian
Latest... Martin Gainty wrote: which version mysql? Martin Gainty __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sen

Re: What files to install for Windows

2008-12-26 Thread Menachem Bazian
Manish Sinha wrote: Menachem Bazian wrote: If I were building an install for MySQL on windows, what files would I have to include in the installer? Is there a list somewhere? Why would you want to build MySQL for windows. Isn't a binary available for the same? No offense meant, but just inq

Re: Can't get expected SELECT GROUP BY results

2008-12-26 Thread Peter Brawley
Sorry LOL, make that http://www.artfulsoftware.com/infotree/queries.php. PB - Peter Brawley wrote: What I want to do is SELECT only the most recent dateTime and critterXYZ for each critterName and return one row for each unique critterName. For examples & discussion see "Within-group ag

Re: Can't get expected SELECT GROUP BY results

2008-12-26 Thread Peter Brawley
What I want to do is SELECT only the most recent dateTime and critterXYZ for each critterName and return one row for each unique critterName. For examples & discussion see "Within-group aggregates" at http://localhost/artful/infotree/queries.php. PB - Fish Kungfu wrote: I have a datase

Re: Question on default database for stored functions

2008-12-26 Thread Peter Brawley
select get_area(11); ERROR 1305 (42000): FUNCTION test2.get_area does not exist Can someone tell me what I'm doing wrong? Thanks. SELECT dbWhereFunctionWasCreated.get_area(11); PB - Jerry Schwartz wrote: -Original Message- From: blue.trapez...@gmail.com [mailto:blue.trapez...@

Can't get expected SELECT GROUP BY results

2008-12-26 Thread Fish Kungfu
I have a dataset like this: +++--+-+ |regionName|critterName|critterXYZ|dateTime | +++--+-+ |

RE: Question on default database for stored functions

2008-12-26 Thread Jerry Schwartz
>-Original Message- >From: blue.trapez...@gmail.com [mailto:blue.trapez...@gmail.com] On >Behalf Of Vikram Vaswani >Sent: Thursday, December 25, 2008 5:47 AM >To: mysql@lists.mysql.com >Subject: Question on default database for stored functions > >Hi > >According to the MySQL manual, "By

Re: What files to install for Windows

2008-12-26 Thread Manish Sinha
Menachem Bazian wrote: If I were building an install for MySQL on windows, what files would I have to include in the installer? Is there a list somewhere? Why would you want to build MySQL for windows. Isn't a binary available for the same? No offense meant, but just inquisitive to know. --

What files to install for Windows

2008-12-26 Thread Menachem Bazian
If I were building an install for MySQL on windows, what files would I have to include in the installer? Is there a list somewhere? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org