Is there any output from the command? Any errors? Try SHOW CREATE TABLE xxxxx. It should show you the TYPE= at the end.
out. On Thu, 21 Oct 2004 11:10:10 +0200, Stefan Gnann <[EMAIL PROTECTED]> wrote: > Hi all, > > I have a mysql database 4.0.15 on a suse linux 9.x system running. > Now we have to use the features of InnoDB tables (rollback, a.s.o.). > Up to now we use the standard table type MyISAM. > Now I want to change the tabel type with the command "ALTER TABLE xxxxx TYPE > = InnoDB". > The command doesn´t show any effect !!! > > What can I do to change the table type? > What did I have to do to change the table type?? > > best regards > > Steve > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]