This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I'm trying to create a table in MySql with 2 columns as the primary key. I tried this: create table workout ( userId varchar(32) primary key, workoutId mediumint primary key, workoutDate date, workoutType tinyint, creationDate date, lastUpdateDate timestamp, lastUpdateUserId varchar(32) ) type=InnoDB; but it didn't work... Any suggestions? ms