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, octet2, octet3, octet4)". or am I not understanding your question? Regards, -Ryan Hatch * remember me? yesterday #php on DALNet, G3X7 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 > > 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 --------------------------------------------------------------------- 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
