Friday, December 14, 2012

How to add composite primary key in MySQL

Adding composite primary key in MySQL 



ALTER TABLE tablename
  DROP PRIMARY KEY,
  ADD PRIMARY KEY (columnID1,columnID2,columnID3);

No comments:

Post a Comment

Popular Posts