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
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
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
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)
;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
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
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
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:
>&
Hello all,
I'm running MySQL on SuSE Linux 7.0.
I've been unable to connect to MySQL from a client on a remote system (both
systems behind the firewall) using a username/pw set up locally using the
GRANT ALL ON *.* TO user@% identified by "password" command.
I know this is a big security hole t
