[prev in list] [next in list] [prev in thread] [next in thread] 

List:       msql-mysql-modules
Subject:    RE: How can I build  multiple indexes in  Mysql?
From:       "Tupshin Harper" <tupshin () tupshin ! com>
Date:       1998-10-18 17:59:46
[Download RAW message or body]

That's what the SELECT DISTINCT syntax is for.  Look for that in the MySQL
manual or any SQL documentation.

-Tupshin Harper
-Programmer/Network Administrator
-Studio Verso

> -----Original Message-----
> From: owner-msql-mysql-modules@tcx.se
> [mailto:owner-msql-mysql-modules@tcx.se]On Behalf Of Crystal Haskins
> Sent: Sunday, October 18, 1998 7:35 AM
> To: msql-mysql-modules@tcx.se
> Subject: How can I build multiple indexes in Mysql?
>
>
> Hi,
>
> I'm writing an application using Perl and Mysql (in a UNIX environment)
> to track web server statistics and I ran into a problem with tracking
> page access by unique visitors (defined as unique visitors within a 24
> hr period).  I'm not sure how to do this with a "SELECT" statement. I
> want to eliminate duplicate records.  Do I create a index that combines
> both fields HOST and URL? Can someone give me an example of how this is
> done?  I would appreciate any suggestions!
>
> Here is some sample data:
>
> HOST		URL
> ----		---
> 123.45.678	www.anysite1.com
> 123.45.678	www.anysite1.com
> 100.12.345	www.anysite2.com
> 100.12.345	www.anysite2.com
>
> Thanks so much!
>
> Crystal
> -----------------------------------------------------------
> Send a mail to mdomo@tcx.se with
> unsubscribe msql-mysql-modules your@subscription.address
> in the body of the message to unsubscribe from this list.
>

-----------------------------------------------------------
Send a mail to mdomo@tcx.se with
unsubscribe msql-mysql-modules your@subscription.address
in the body of the message to unsubscribe from this list.

[prev in list] [next in list] [prev in thread] [next in thread]