Neptunus Maris Posted October 14, 2006 Share Posted October 14, 2006 I have a general understanding of what the unique column of a table is...I need to know the difference between Unique and Index fields. and please define them, my book doesnt go in dept.Thanks in advanceNeptune Quote Link to comment https://forums.phpfreaks.com/topic/23961-index-and-unique/ Share on other sites More sharing options...
Barand Posted October 15, 2006 Share Posted October 15, 2006 Exactly as it says on the tin. Values in a unique index cannot have duplicates. If the index comprises more than one column then the combination of values must be unique.So if your current index values are , say[pre]blue | 1blue | 2red | 1red | 3[/pre]you could add "blue, 3" but not another "blue, 2" Quote Link to comment https://forums.phpfreaks.com/topic/23961-index-and-unique/#findComment-109006 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.