Paul,
>> > > I am doing queries that produce a table that looks
something like this:
>> > >
>> > > Count | IP Address | First Seen | Last
Seen | Days
>> > > 5000 10.0.0.1 2005-12-10
2006-04-15 50*
>> > > 6500 10.0.0.2 2006-04-01
2006-04-06
--- Paul Halliday <[EMAIL PROTECTED]> wrote:
> On 4/23/06, John Hicks <[EMAIL PROTECTED]> wrote:
> > Paul Halliday wrote:
>
> > > I am doing queries that produce a table that looks something like
> this:
> > >
> > > Count | IP Address| First Seen| Last Seen | Days
> > > 5000
On 4/23/06, John Hicks <[EMAIL PROTECTED]> wrote:
> Paul Halliday wrote:
> > I am doing queries that produce a table that looks something like this:
> >
> > Count | IP Address| First Seen| Last Seen | Days
> > 5000 10.0.0.1 2005-12-102006-04-15 50*
> > 6500
I am doing queries that produce a table that looks something like this:
Count | IP Address| First Seen| Last Seen | Days
5000 10.0.0.1 2005-12-102006-04-15 50*
6500 10.0.0.2 2006-04-012006-04-06 3**
*So of the 5000 events "count(*) bet
Paul Halliday wrote:
I am trying to formulate a query that will increment if a condition is true.
For example, if I do a select (just let me know if there was data on
this day, if so increment count by 1 and check the next day) where
timestamp between jan and feb.
Could you be a bit more speci
I am trying to formulate a query that will increment if a condition is true.
For example, if I do a select (just let me know if there was data on
this day, if so increment count by 1 and check the next day) where
timestamp between jan and feb.
Thanks.
--
MySQL General Mailing List
For list archi