David542 David542 - 6 months ago 38
SQL Question

ALTER TABLE to add a composite primary key

I have a table called

. I have three columns called
. There can be duplicate persons, duplicate places, and duplicate things, but there can never be a dupicate person-place-thing combination.

How would I ALTER TABLE to add a composite primary key for this table in MySQL with the these three columns?

Answer Source
ALTER TABLE provider ADD PRIMARY KEY(person,place,thing);

If a primary key already exists then you want to do this

ALTER TABLE provider DROP PRIMARY KEY, ADD PRIMARY KEY(person, place, thing);
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download