Hi
I want to enforce unique records in one of my
tables.
The table goes like this:
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
customerID INT UNSIGNED,
categoryname VARCHAR(20)
With customer ID pointing to a customers table.
I suddenly realized that one customer could input
the same "categoryname" twice, which would create
a duplicate entry in the database. (if you ignore the
primary key).
Is there something in
MySQL, or in my table design, that can force unique records?
Or will I have to check this with my code everytime I
update the database?
Thanks very much for any help! Much appreciated.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php