RE: how to set the column's property? - indrek siitan - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRE: how to set the column's property?

From	Sent On	Attachments
Andras Balogh	15 Nov 2000 05:21
indrek siitan	15 Nov 2000 05:23
philipshk	15 Nov 2000 21:15

Subject:	RE: how to set the column's property?
From:	indrek siitan (tf...@mysql.com)
Date:	11/15/2000 05:23:00 AM
List:	com.mysql.lists.mysql

Hi,

Dear all: I need to build a table with the following conditions: In any record, the contents of column 1 and column 2 must be unique (combined), but the content of column 1 or column2 need not to be unique respectively. How can I set the column property to realize this kind of table!

ALTER TABLE tablename ADD UNIQUE (column1,column2);

Rgds, Tfr