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
