Hello, I created table a while back like so: CREATE TABLE CATEGORY ( cat_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, parent_id INT, visible varchar(1) NOT NULL DEFAULT 'Y', sort INT, name varchar(200) ) TYPE=InnoDB;
I believe I created it as type InnoDB for a foreign key relationship . Anyway, I want to create a fulltext index on the table, but I cannot because it is not supported by InnoDB, but by MyISAM (according to the docs). As it stands I have 1000+ records in the table, and do not know what to do. Can I alter the table to be MyISAM? And what is a MyISAM vs InnoDB? This always confuses me. And if I can alter to MyISAM, can I still have it related to a foreign key for delete on cascades? Thanks Scott -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]