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. 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`) 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? 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 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
Archived
This topic is now archived and is closed to further replies.