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]