CodingForums.com - View Single Post

Old Pedant · 02-22-2013, 07:08 AM

We are in violent agreement. On all points. How strange <grin style="sheepish" />

And I amazed at the number of people who don't realize that a primary key can be a composite key.

I actually have some tables with only 3 fields where the primary key is...all three fields! (And because of MySQL's mildly braindead use of indexes, it's mightily important what order the field are listed in the composite primary key. But oh man, when it's done right does it give wonderful performance!)

02-22-2013, 07:08 AM	PM User \| #7
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,172 Thanks: 59 Thanked 3,994 Times in 3,963 Posts	We are in violent agreement. On all points. How strange <grin style="sheepish" /> And I amazed at the number of people who don't realize that a primary key can be a composite key. I actually have some tables with only 3 fields where the primary key is...all three fields! (And because of MySQL's mildly braindead use of indexes, it's mightily important what order the field are listed in the composite primary key. But oh man, when it's done right does it give wonderful performance!) __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is. Last edited by Old Pedant; 02-22-2013 at 07:10 AM..