List:General Discussion« Previous MessageNext Message »
From:chriswhite Date:April 27 2006 3:45pm
Subject:Re: Multiple primary keys
View as plain text  
Quoting nngau <nngau@stripped>:

> Can someone figure out what's going on. This is the only change
> I made to this table. Basically I don't want any duplicate rows, so
> I setup 4 fields to be my primary key.

If you don't want any duplicate rows, use UNIQUE, all those primary keys will
just take up unwanted space. If you still think these fields should be indexed
due to the large number of hits, then use an INDEX.

Chris White

Thread
Update not working in a script, but going fine running with MySQL Browserluis perez27 Apr
  • Re: Update not working in a script, but going fine running withMySQL Browsermysql27 Apr
    • Multiple primary keysnngau27 Apr
      • Re: Multiple primary keyschriswhite27 Apr
      • Re: Multiple primary keysKishore Jalleda27 Apr
        • RE: Multiple primary keysnngau27 Apr
          • Re: Multiple primary keysGordon27 Apr