InnoDB of course does not supportFULLTEXT indexes, and so forth.
Which is a pain, because i want the foreign key relationships but fulltext indexing at the same time :\
As for transactions , is it simply by doing this?
start transaction do query commit if error rollback
Not quite. It's either commit or rollback, not commit and possibly rollback.
start transaction do query if error rollback else commit
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
