ALTER TABLE tablename ADD UNIQUE (Column1, Column2); Best Regards, Andrew
> Can someone explain how I can make a combination of two fields be a > unique index. > > For example, in my table I have an OrderID field and a LineItems field. > Individually the fields are not unique but when combined they are. I'd > like to create a unique index of the two together but not individually. > > Thanks for the help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]