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]

Reply via email to