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
