plznty Posted May 23, 2009 Share Posted May 23, 2009 I want it so say username ryan was taken. There is no other way to put another ryan in. Thanks alot. Quote Link to comment https://forums.phpfreaks.com/topic/159332-how-do-i-enable-unique-fields-on-phpmyadmin/ Share on other sites More sharing options...
MadTechie Posted May 23, 2009 Share Posted May 23, 2009 Select the table then the Structure tab, on the right of the users field click the 5th icon (one with the U) or run the query ALTER TABLE `table` ADD UNIQUE (`Users`) Quote Link to comment https://forums.phpfreaks.com/topic/159332-how-do-i-enable-unique-fields-on-phpmyadmin/#findComment-840374 Share on other sites More sharing options...
plznty Posted May 23, 2009 Author Share Posted May 23, 2009 It has the U like faded out. Is it to do with the field being called username? Quote Link to comment https://forums.phpfreaks.com/topic/159332-how-do-i-enable-unique-fields-on-phpmyadmin/#findComment-840378 Share on other sites More sharing options...
MadTechie Posted May 23, 2009 Share Posted May 23, 2009 it means you can't make it unique. i kinda need more detail could toy export the structor Quote Link to comment https://forums.phpfreaks.com/topic/159332-how-do-i-enable-unique-fields-on-phpmyadmin/#findComment-840392 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.