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 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" Link to comment https://forums.phpfreaks.com/topic/23961-index-and-unique/#findComment-109006 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.