On 2007-01-04 Octavian Rasnita wrote: > I have seen that by default some tables are created as InnoDB and some as > MyISAM. > > I guess the table type is not chosen randomly. How is it chosen the table > engine used? You can set a global and IIRC a database specific default for the database type. > And is InnoDB recommended now? It depends.. :)
> Does it support full text indexes? > Or if not, is there a way of using full text indexes and foreign keys in > MySQL? No fulltext indexes in InnoDB and no foreign keys in MyISAM as of 5.0. bye, -christian- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]