|
|
Posted by Curtis on 01/26/07 11:02
On Jan 25, 5:58 am, Rik <luiheidsgoe...@hotmail.com> wrote:
> On Thu, 25 Jan 2007 14:42:01 +0100, Erwin Moller
> > Still mySQL should really consider improving their FK support.
> > After all, that is what 'relational' means in a relational database. ;-)
> Yup.
> What's worse, a lot of (cheaper) hosters do have MySQL, but don't allow
> InnoDB tables. Unfortunately, I've grown quite accustomed to write my own
> integrity queries for projects where for some reason people liked to pay
> tons of money for bad hosting, and refused to switch.... It's a terrible
> paint to have check up to ten tables manually on every delete and update.
>
> Then again, a colleague of mine hates database-enforced referential
> integrity, for the simple reason he can't find it in his own code...
> --
> Rik Wasmus
> * I'm testing several new newsreaders at the moment. Please excuse
> possible errors and weird content. *
The MySQL (4 and 5) documentation gave a vague statement that they'd
implement foreign key support for MyISAM tables in later versions. I
don't keep up with the bleeding edge for MySQL, so I don't have any
idea what the specs are, or if available at all in their CVS, for MySQL
6. At the very earliest, it would have to have to be 6+, I would
imagine.
By the way, good luck with your SQL adventures, Erwin. ;-)
--
Curtis
Navigation:
[Reply to this message]
|