Now this is rather useful in my opinion. I will be passing it on to some
of my collegues.
Aly.
On Thu, 6 Oct 2005, Jim C. Nasby wrote:
On Thu, Oct 06, 2005 at 10:10:14AM -0500, Scott Marlowe 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.
Are you aware of the MySQL Gotchas website (just google it)? Any time
you see MySQL being stupid about something you should probably check
there first to see if it's a "feature".
--
Aly S.P Dharshi
aly.dharshi@xxxxxxxxx
"A good speech is like a good dress
that's short enough to be interesting
and long enough to cover the subject"
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
