I have a table called provider. I have three columns called a person, place, thing. There can be duplicate persons, duplicate places, and duplicate things, but there can never be a duplicate person-place-thing combination.
How would I ALTER TABLE to add a composite primary key for this table in MySQL with these three columns?