SQL trouble and google isn't being helpful.

Joshua Marsh joshua at themarshians.com
Sat Dec 14 14:57:37 MST 2013


On Sat, Dec 14, 2013 at 2:47 PM, S. Dale Morrey <sdalemorrey at gmail.com>wrote:

> I have a table that looks like this...
>
> Index (self incrementing number), Address (string), Transaction (string),
> Amount (probably long)
>
> What I need to do is enforce a rule that a given combination of address and
> transaction must be unique without making either Address or Transaction,
> individually unique.
>

I may not be understanding what you are asking, but I think most SQL
database have UNIQUE indexes. For example, in MySQL:

CREATE UNIQUE INDEX AddressTransaction ON Table (Address, Transaction);


More information about the PLUG mailing list