-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Levi Smith wrote: > So, now I'm trying to develop this database for an antiques store where one > item could be in multiple categories, and I think I've gathered enough > (almost) to lay out the structure and was almost there. But now I've > realized that the foreign keys seem to actually need to be defined in the > database. I then found that apparently I need to use the InnoDB type to do > that? Then I go to look at my webhost and I only have options for MyISAM, > Heap, ISAM and Merge.
Yes, if you really want foreign keys to work and enforce consistancy you need to be using the innodb type. Do you have the option of upgrading your mysql? If so I would recommend going with mysql 5. It is technically still beta but it is late beta. I am using it and having good success with it. It includes all of the features dba's have been panning mysql over for years so mysql should now finally be counted as a full fledged rdbms. - -- Tracy R Reed http://ultraviolet.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFDA1xs9PIYKZYVAq0RAjGdAJ9MBCsaCbQyBo6HCceCZydMbeGzTQCgimyj krIRNlWkt9Gmx3MK55cCO7A= =Oy4M -----END PGP SIGNATURE----- -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
