Page 1 of 1

MyTable1.TableType ?

Posted: Thu 20 Nov 2008 18:23
by cybsistemas
As I can know if a table is MyISAM or InnoDB ?

Posted: Fri 21 Nov 2008 08:18
by jkuiper
It depens how your table in the mysql database is created

Posted: Fri 21 Nov 2008 11:23
by Dimon
The TMyTable component does not allow to learn the table type directly. To learn about the table engine, execute the following SQL query:

Code: Select all

SHOW TABLE STATUS WHERE NAME = 'TableName'

Posted: Fri 21 Nov 2008 11:30
by cybsistemas
Thank you very much