title: Mysql: How do you create a table with multiple primary keys?
body: <p>I have this situation:</p>
  
  <p><a href="https://stackoverflow.com/questions/1590033/mysql-newbie-question-which-are-the-pk-and-the-fk-for-this-tables">MySQL - Newbie question: Which are the PK and the FK for these tables?</a> (take a look at the table <strong>Salaries</strong>)</p>
  
  <p>How do you create a table with multiple primary keys?</p>
  
  <pre><code>create table salaries
  (
    dep_id smallint auto_increment primary key, 
    emp_id smallint auto_increment primary key, 
    bla varchar(20)
  );
  </code></pre>
  
  <p>I receive an error if I try the code above. Any ideas?</p>