Scott Purcell wrote:
Hello,
I posted last night but did not receive an answer. I am trying to create a
fulltext index, but my table was created as an InnoDB type.
There is quite a bit of data there (1000+ records) and I need to change to a
MyISAM table for the indexing for fulltext search.
How can I convert the InnoDB to a MyISAM, and also, when using MyISAM, can I
have foreign key relationships?
- ALTER TABLE table_name TYPE=MyISAM;
- and no, you can't have foreign keys with MyISAM tables--or rather,
there's nothing preventing you using foreign keys but you will have to
enforce referential integrity programmatically. MySQL won't do it for you.
- ian
--
+-------------------------------------------------------------------+
| Ian Sales Database Administrator |
| |
| "All your database are belong to us" |
| ebuyer http://www.ebuyer.com |
+-------------------------------------------------------------------+
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
