| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Gabriel PREDA | Date: | October 6 2006 10:31am |
| Subject: | Re: multiple primary keys on one table? | ||
| View as plain text | |||
You will have to UPDATE to NULL those fields, modify the aplication to enter NULL instead of empty-string... Then add the UNIQUE INDEX... In MySQL (unless modified) the dafault is that NULL values are incomparable thus allowing the creation of a UNIQUE INDEX. -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer
| Thread | ||
|---|---|---|
| • multiple primary keys on one table? | Ferindo Middleton | 5 Oct |
| • Re: multiple primary keys on one table? | Dan Buettner | 5 Oct |
| • Re: multiple primary keys on one table? | Ferindo Middleton | 6 Oct |
| • Re: multiple primary keys on one table? | Gabriel PREDA | 6 Oct |
| • Re: multiple primary keys on one table? | Miles Thompson | 6 Oct |
| • Re: multiple primary keys on one table? | Martijn Tonies | 6 Oct |
| • Re: multiple primary keys on one table? | Renish | 6 Oct |