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