[ciapug] MySQL, MyISAM, Triggers

[carl-olsen at mchsi.com]

I keep learning more about MySQL and I recently discovered that full text indexing does not work with the InnoDB table type.  I also discovered that foreign keys do not work with MyISAM table types.  What to do?

I have a table with configuration values that relate to pages on my website.  Each page can have a configuation setting with the same name and value, but I don't want two cofiguration settings with the same name for a page.  I want to index the two columns in the table, the configuration setting name and the page it relates to, but I can't do this unless I change the table type to InnoDB.

Can I do this with a trigger and still use the MyISAM table type?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cialug.org/pipermail/ciapug/attachments/20061027/a27030fa/attachment.html