On Thu, 2005-10-06 at 14:35, CSN wrote: > --- Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> wrote: > > > > > But what really bugs me is that some things that ARE > > bugs simply aren't > > getting fixed and probably won't. Specifically, > > while mysql understands > > fk references made at a table level, it simply > > ignores, without error, > > warning, or notice, fk references made in a column. > > arg... Very > > frustrating. If they just didn't support that > > syntax it would be much > > less bothersome, since I'd try it, get an error, and > > try the other > > syntax. Instead, I spent an afternoon trying to > > figure out why it > > wasn't doing ANYTHING when I declared an FK > > reference at column level. > > > > Things like that are, sadly, kinda rampant in MySQL. > > > > What's the difference between a fk at the table level > vs. column level? The only fk's I've used are one > column referencing another. It's just where they're defined. See this bug for an explanation: http://bugs.mysql.com/bug.php?id=13301 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
