--Original Message-
From: Scott Purcell [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 25, 2006 3:55 PM
To: mysql@lists.mysql.com
Subject: Create a constraint over 3 columns.
I would like to be able to avoid inserting a duplicate record. The
duplication consists of 3 columns though.
Here is th
I would like to be able to avoid inserting a duplicate record. The duplication
consists of 3 columns though.
Here is the scenario.
I have this existing table item (which is a product item)
CREATE TABLE ITEM (
parent_id INT NOT NULL default 0,
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
