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 Quote 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. Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/140103-remove-unique-requirement-how/#findComment-734562 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.