<div>
A primary key is, by definition, a unique key.<br />
<br />
Kent<br />

</div>


A primary key is, by definition, a unique key.

Kent


<div>
<div class="content wysiwyg-content">
Hi, just wanted to know if a primary key can have duplicate values?<br />
<br />
I have one table (courses) which has an 'id' field.<br />
<br />
Then i have another table (bookings) where i want to store various bookings for each course, but need to store the same 'id' so they can be linked.<br />
<br />
Can this be done?<br />
Thanks
</div>
</div>


Hi, just wanted to know if a primary key can have duplicate values?

I have one table (courses) which has an 'id' field.

Then i have another table (bookings) where i want to store various bookings for each course, but need to store the same 'id' so they can be linked.

Can this be done?
Thanks

MySQL Database Unique Primary Keys?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.