ALTER TABLE to add a composite primary key

by 
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);

More Related Contents:

  1. How to properly create composite primary keys – MYSQL
  2. difference between primary key and unique key
  3. Remove Primary Key in MySQL
  4. ALTER table – adding AUTOINCREMENT in MySQL
  5. Strings as Primary Keys in MYSQL Database [closed]
  6. How do I import an SQL file using the command line in MySQL?
  7. How to select the nth row in a SQL database table?
  8. MySQL – How to unpivot columns to rows?
  9. UPDATE multiple rows with different values in one query in MySQL
  10. MySQL SELECT only not null values
  11. Detect if value is number in MySQL
  12. Difference between two dates in MySQL
  13. How do I create a sequence in MySQL?
  14. MySQL search and replace some text in a field
  15. MySQL: ALTER TABLE if column not exists
  16. Can I reuse a calculated field in a SELECT query?
  17. Group mysql query by 15 min intervals
  18. Using Count to find the number of occurrences
  19. Is there any reason to worry about the column order in a table?
  20. MySQL: LIMIT by a percentage of the amount of records?
  21. limiting the rows to where the sum a column equals a certain value in MySQL
  22. MySql Transpose Row into Column and Column into Row [duplicate]
  23. MySQL Inner Join Query Multiple Tables
  24. How to select column names dynamically in mySQL
  25. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  26. MySQL LEFT JOIN 3 tables
  27. MySql using correct syntax for the over clause
  28. MySQL OPTIMIZE all tables?
  29. Strip last two characters of a column in MySQL
  30. Deleting a row based on the max value

Leave a Comment