birowakskip Posted August 27, 2007 Share Posted August 27, 2007 I really need to change the primary key to one table in my database. Is there a way I can do so without deleting the whole table. Link to comment https://forums.phpfreaks.com/topic/66838-solved-changing-properties-to-field-in-mysql-table/ Share on other sites More sharing options...
Illusion Posted August 27, 2007 Share Posted August 27, 2007 ALTER TABLE tablename DROP PRIMARY KEY, ADD PRIMARY KEY(newcolumn1,newcolumn2,....); Link to comment https://forums.phpfreaks.com/topic/66838-solved-changing-properties-to-field-in-mysql-table/#findComment-335072 Share on other sites More sharing options...
birowakskip Posted August 27, 2007 Author Share Posted August 27, 2007 Thanks alot Link to comment https://forums.phpfreaks.com/topic/66838-solved-changing-properties-to-field-in-mysql-table/#findComment-335127 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.