tomg

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/mysql?unsub=m...ie.nctu.edu.tw

newsy

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/mysql?unsub=m...ie.nctu.edu.tw

mc5422

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/mysql?unsub=m...ie.nctu.edu.tw