Re: Desperate Sum(), Group by/Join question - One Step closer...

Ok, in regards to my previous dilemma, I've gotten it to: SELECT golf_pick_periods.id, golf_pick_periods.period_name, golf_pick_periods.period_start_date, golf_pick_periods.period_end_date, COUNT(DISTINCT golf_events.id) AS num_events, COUNT(golf_pla

Desperate Sum(), Group by/Join question

r the periods and in each period counting the picks. Help! Best, Peter D Bethke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque

Desperate Sum(), Group by/Join question

r the periods and in each period counting the picks. Help! Best, Peter D Bethke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque

CASE statement within SUM()

l_sum (Of course this doesn't seem to work, but it's the best I can approximate) Any help, much much appreciated. Best, Peter D Bethke - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Multi-table summary SQL problem/question

;win" (ie a correct guess) or a "loss" (incorrect guess). Then sum that result over time to determine player rankings, ie the player with the most "wins" is at the top of the list. Any input, general direction or (best

Re: Failed Config on Mac OSX

Russell, Sounds like you don't have developer tools installed. You need the developer tools to build mysql on OSX. Though I think you can get hold of a pre-built distro as well - try versiontracker to find the link. Peter > This is my first time installing MySQL. > > I'm attempting to install M

Use a function?

Hello all, I'm creating a db to track a contest involving sports teams and scores. My table "matchups" has columns for team1_id, team2_id, team1_score and team2_score. I can write a simple calculation using the api I use (Lasso - similar in function to php) and display the results programmatical

Re: WNT Perl to Linux MySQL

Hi Paul, I think CACAW8428 is the NT Nodename and not the DNS Name. Replace the CACAW8428 in your user and db table with the IP Address of your Workstation 10.9.8.8 and it should work. After you veryfied that the connect works reduce the access right to the needed. kind regards Peter Bethke

Re: MySQL compilation problems, Solaris 8

Hi Mark, I had the same problem too. I downloaded the gcc 2.95.3 and compiled it myself. Using thatt gcc to compile MySQL, and everything worked fine. kind regrads Peter Bethke - Before posting, please check: http

Re: MySQL remote connect

in to NT as the user in the GRANT statement. Help! Peter > From: Sinisa Milivojevic <[EMAIL PROTECTED]> > Date: Fri, 1 Jun 2001 21:31:48 +0300 (EEST) > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL remote connect > > Peter D Bethke writes: >&

MySQL remote connect

this darned thing to work? Best, Peter Bethke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL