mysql unique columns

[chrisleon]

I know I can set a column to be unique, and if I try to add a record that has the same id as one before, it will say duplicate id found in key blah. Anywayz, I was wondering if I can specify two unique id's to check on.

ie.

if the bill to of a customer is 067351

I want to be able to add 067351 as many times as I want, but has to be a unique user id

067351|sam |password
067351|joe |password
067351|bob |password

so I need to be able to check if the bill to has a user id that is the same.

Is this possible?

[ahundiak]

Yep.
CREATE UNIQUE INDEX i1 ON table_name(column1_name,column2_name);

It's truely amazing what you can find out by looking in the manual.

[chrisleon]

what does the i1 stand for?

[Sxooter]

Originally posted by chrisleon
what does the i1 stand for?

It's just the index name.

[chrisleon]

it worked great, thanks so much