 <p>Modifying the primary key on a table is a tricky exercise. This is doubly true when the existing key is defined <code>auto-increment</code>. </p> <p>You can create a composite unique key, though. </p> <pre><code>ALTER TABLE ADD UNIQUE KEY (`column1`, `column2'); </code></pre>