List:General Discussion« Previous MessageNext Message »
From:Myk Melez Date:May 22 2002 9:17pm
Subject:Re: columb structure
View as plain text  
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 single index, individual
columns can contain values that are duplicated in other rows as long as
the combination of values is unique.

-myk

--
[sql, mysql, query]

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