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" <[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 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 > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
