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]
