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