![]() ![]() If the system variable 'have_innoDB' has the value of "YES" it is available. However some ISP's disable it (completely or for some (the cheapest!) 'hosting plans' only). InnoDB is included in every recent binary distributed by MySQL AB. ![]() Currently SQLyog supports Foreign Keys with both InnoDB and Primbase XT and SolidDB.įoreign Key constraints are (almost) functionally identical to 'relationships' in some databases like Microsoft Access.ĭepending on the MySQL version and the platform where it is running, InnoDB may or may not be available, and PrimeBase XT will only be available where it has been installed as a 'plugin' (addition) to the server as shipped by MySQL AB. Also the Falcon storage engine by MySQL AB will have FK's functional enabled at a later point of its development. InnoDB still is the only table TYPE (or 'ENGINE' as is the correct term form MySQL version 4.1) supporting Foreign Key Constraints that MySQL AB ship themselves, but the third party Engines 'PrimeBase XT' or just PBXT and SolidDB are now available with Foreign Key support. With MySQL version 5.1 MySQL AB introduced what they call the 'pluggable Storage Engine architecture' so that (third party or experimental) Engines can be added without recoding and compiling the MySQL server itself. They were introduced in the MySQL 3.23 tree. An InnoDB tables was the first table type available in MySQL supporting Foreign Keys. Among other features some Table Engines support FOREIGN KEY constraints. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |