Chris Knipe wrote:
>Multiple subnets :/
>
>columns like this:
>octet1, octet2, octet3, octet4
>195,196,192,23
>232,196,231,11
>
>This would then be seen as a duplicate
Not if you have a single index spanning all four columns (as opposed to
four indexes, one on each column). With the sin
TECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 9:59 PM
Subject: Re: columb structure
> you're not making much sense to me
>
> in your first post... you wanted make sure every IP you have is unique,
correct?
>
> Do an ALTER TABLE with "UNIQUE(octet1, o
ervices
> Tel: +27 21 854 7064
> Cell: +27 72 434 7582
>
> - Original Message -
> From: "Myk Melez" <[EMAIL PROTECTED]>
> To: "Chris Knipe" <[EMAIL PROTECTED]>
> Cc: "mysql" <[EMAIL PROTECTED]>
> Sent: Wednesday, May
t;Myk Melez" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 8:43 PM
Subject: Re: columb structure
> Chris Knipe wrote:
>
> >I'm currently storing them into varcha
Chris Knipe wrote:
>I'm currently storing them into varchar(16), although I've been thinking of
>doing it as for smallint columns, but then I can't be 100% certain I won't
>get duplicates.
>
Why not? Just define a UNIQUE index across all four smallint columns,
and MySQL will throw an error
Hi all,
What's the best way to store a numeric IP address into a table with the
least possible size and overhead on the mysql server?
I'm talking millions of records here With not one single duplicate IP
address (unique index)..
Currently, the database hosts just over 1.2 million unique add
