MyTable1.TableType ?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cybsistemas
Posts: 118
Joined: Mon 12 Sep 2005 17:31
Location: Argentina

MyTable1.TableType ?

Post by cybsistemas » Thu 20 Nov 2008 18:23

As I can know if a table is MyISAM or InnoDB ?
Top
jkuiper
Posts: 138
Joined: Fri 04 Aug 2006 14:17

Post by jkuiper » Fri 21 Nov 2008 08:18

It depens how your table in the mysql database is created
Top
Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 21 Nov 2008 11:23

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'
Top
cybsistemas
Posts: 118
Joined: Mon 12 Sep 2005 17:31
Location: Argentina

Post by cybsistemas » Fri 21 Nov 2008 11:30

Thank you very much
Top
Post Reply

Return to “MySQL Data Access Components”