declare the two fields you want unique as such? unique index.
alec Kory Wheatley wrote:
I have a database called accountcreation, and I want to setup a table called accountinfo. This table will require that two out of the three fields need to be "UNIQUE", I don't want duplications in these fields. One field is a integer value the other field is a character value. What is the best way to set this table up?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]