List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:May 22 2002 6:50pm
Subject:Re: columb structure
View as plain text  
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


Kind Regards,

Chris Knipe
MegaLAN Corporate InterNetworking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582

----- Original Message -----
From: "Myk Melez" <myk@stripped>
To: "Chris Knipe" <savage@stripped>
Cc: "mysql" <mysql@stripped>
Sent: Wednesday, May 22, 2002 8:43 PM
Subject: Re: columb structure


> 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 if you attempt to insert a duplicate
> record into the table.
>
> -myk
>
>
>

Thread
columb structureChris Knipe22 May
  • Re: columb structureMyk Melez22 May
  • Re: columb structureChris Knipe22 May
  • Re: columb structureRyan Hatch22 May
  • Re: columb structureChris Knipe22 May
  • Re: columb structureMyk Melez22 May