And who said you ever get to old to learn :) Never knew I could do unique indexes like this...... Definitely what I'm looking for... Thanks guys :)
-- me ----- Original Message ----- From: "Ryan Hatch" <[EMAIL PROTECTED]> To: "Chris Knipe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 22, 2002 9:59 PM Subject: Re: columb structure > 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