tqla Posted January 9, 2009 Share Posted January 9, 2009 Hello. I am using MyPHPAdmin version 3.1.1. I clicked the Unique icon in the action section of my 'email' field so that there will be no duplicate entries. My question is this. How do I reverse this? I don't see an Icon to remove this requirement. Does anybody know if they actually is a way to reverse it? Thanks Link to comment https://forums.phpfreaks.com/topic/140103-remove-unique-requirement-how/ Share on other sites More sharing options...
fenway Posted January 9, 2009 Share Posted January 9, 2009 I believe you have to drop it, then re-create it... you can do this in a single pass with ALTER TABLE. Link to comment https://forums.phpfreaks.com/topic/140103-remove-unique-requirement-how/#findComment-733118 Share on other sites More sharing options...
tqla Posted January 9, 2009 Author Share Posted January 9, 2009 Really. That's what I thought but I was hoping not. That means that if the Field has a lot of entries in it then you lose them. I suppose you can backup the DB first; Drop the field, recreate the field, and then reupload the DB. Link to comment https://forums.phpfreaks.com/topic/140103-remove-unique-requirement-how/#findComment-733124 Share on other sites More sharing options...
fenway Posted January 11, 2009 Share Posted January 11, 2009 Really. That's what I thought but I was hoping not. That means that if the Field has a lot of entries in it then you lose them. I suppose you can backup the DB first; Drop the field, recreate the field, and then reupload the DB. No... I meant drop the INDEX, not the FIELD. Link to comment https://forums.phpfreaks.com/topic/140103-remove-unique-requirement-how/#findComment-734562 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.