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
