On Sep 21, 2005, at 10:34 AM, CSN wrote:
id, title, yield, directions
and would like to prevent duplicate records from being
added (i.e. according to the title, yield, and
directions fields).
- Create a unique index across the title, yield, and
directions fields.
This scenario is exactl
I have a table like so:
id, title, yield, directions
and would like to prevent duplicate records from being
added (i.e. according to the title, yield, and
directions fields). I won't normally be querying on
the yield or directions fields, so I just have indexes
for id and title. What's the best w
