When creating a table, can we specify that the combinaison of two fields needs to be unique but each of those two fields may have duplicates, just not both the same?
Can we have a required attribute on one of two fields? I have phone_line_french and phone_line_english, i require one of those two to be filled (or both). I can check that in my script, just asking if we can do it in mySQL Regards, Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 --------------------------------------------------------------------- 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