Referential integrity, FULLTEXT and table types
I need to have a table that supports FULLTEXT searches. This implies that this table should be a MyISAM table. However, I also require that this table act as a parent for child tables in order to support referential integrity. If I create the child tables as INNODB tables, will referential integrity still work with the MyISAM parent table? Many thanks, Tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Referential integrity, FULLTEXT and table types
I need to have a table that supports FULLTEXT searches. This implies that this table should be a MyISAM table. However, I also require that this table act as a parent for child tables in order to support referential integrity. If I create the child tables as INNODB tables, will referential integrity still work with the MyISAM parent table? Hello Tom, Currently you can't use InnoDB tables and Full-Text search, also you can't use MyISAM (which support Full-Text) with foreign keys (it's planned to implement foreign keys in MyISAM tables in MySQL 5.0). So my suggestion: use InnoDB MyISAM together - maybe it isn't referential safe but what can we do... Good luck, Marek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Referential integrity, FULLTEXT and table types
At 16:20 +0100 28-07-2003, Tom Gazzini wrote: I need to have a table that supports FULLTEXT searches. This implies that this table should be a MyISAM table. However, I also require that this table act as a parent for child tables in order to support referential integrity. If I create the child tables as INNODB tables, will referential integrity still work with the MyISAM parent table? Many thanks, Tom If You can do a join between InnoDB MyIsam You can put your text in one table and other data in another table, then link the tables with ids. I'm not sure You can mix InnoDB MyIsam tables in a join. Santino -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]