SQL trouble and google isn't being helpful.
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