index and unique

[Neptunus Maris]

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 advance

Neptune

[Barand]

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 |  1
blue |  2
red  |  1
red  |  3
[/pre]
you could add "blue, 3" but not another "blue, 2"