Why are all MySQL GUI clients so bad with foreign keys? Sorry to seem
annoyed, but I have used for quite some time a few GUI clients, notably
MySQL-Front, which I were relatively confortable with. Anyway, all GUI
clients I used (SQLyog, MySql-Front, MySQL-CC, you name it) seemed to be
some sort of shortcut to the MySQL command line. No problem with that,
that's what I am looking for and not some high-level CASE tool.
It's when looking for foreign keys and referential integrity where these
tools fail miserably. None of them fully supports editing / creating /
deleting foreign keys. If you are to reply to this message, please read
again the "FULLY supports" statement. For example, with version 1.0.7-beta
of MySQL Query Browser (Own MySQL AB tool) I'm unable to add an "ON UPDATE"
constraint... silly, huh? This is not a strange "Fails when lib-foo
v220.127.116.11.7 connects throu a CISCO 90238234 router in a full moon night"
error, it's simply that the programmer (nor the bug-testing labs) have not
tried the "On Update:" drop-down menu from the edit table dialog.
I know foreign keys are a relatively new area in the MySQL field and
maybe the programmers are slowly adding support for it, but it's quite
annoying to see monumental bugs editing and changing foreign keys in ALL
programs I've tried.
Please, note that this message is not intended to flame anyone. I fully
aknowledge the effort involved creating such a tool, I'm a programmer after
all, and some of them are in beta anyway. I would appreciate if anyone knows
some tool which good foreign key support.