What is your goal here? Is this a file linking two other files, the group_conclusion file and the Pad_analysis_result file? Or something like that? Where you search for all of the records with a single group_conclusion and then reference the analysis_result records?
My first question is are these col entries really unique within the columns? If col1 is not unique and col2 is not unique then I suggest a third field to be the primary key and index your two fields as non-unique. -----Original Message----- From: Demirchyan Oganes-AOD098 [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 1:54 PM To: '[EMAIL PROTECTED]' Subject: Creating MySQL table w/2 primary keys Hello everyone, I have this create table statement, drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE; CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), GROUP_CONCLUSION_ID MEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) ) Type=InnoDB; where I want to create table with 2 primary keys, but it won't let me. How could I do it. Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [EMAIL PROTECTED] --------------------------------------------------------------------- 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
