Skip to content

DF_DATABASE_MYSQLTABLETYPE

The type of the MySQL table that will be created by the DataFlex ODBC Driver.

Level

Database

Supported by

ODBC connected to MySQL only, revision 5 and higher

Type

String, temporary

Access

Read/Write

Values

  • "BDB"
  • "HEAP"
  • "InnoDB"
  • "MERGE"
  • "MRG_MYISAM"
  • "MYISAM"

Syntax

Use cli.pkg
Get_Attribute DF_DATABASE_MYSQLTABLETYPE of {driverNumber} {databaseHandle} to {StringVariable}
Set_Attribute DF_DATABASE_MYSQLTABLETYPE of {driverNumber} {databaseHandle} ;
to {"BDB"|"HEAP"|"InnoDB"|"MERGE"|"MRG_MYISAM"|"MYISAM"}

Driver Configuration Keyword

None

Remarks

The type of the MySQL table that will be created by the DataFlex ODBC Driver. MySQL supports several different table types, each having its advantages and disadvantages. See the MySQL documentation for more information on table types. It is recommended to use a table type that supports transactions.

If you retrieve this attribute, the value will have a "TYPE = " prefix compared to the original setting; setting the attribute to "InnoDB" will result in "TYPE = InnoDB" when retrieving it.

Procedure ShowDBAttribute Integer iDriver Handle hDatabase
    String sAttribValue
    Get_Attribute DF_DATABASE_MYSQLTABLETYPE of iDriver hDatabase to sAttribValue
    Showln "MySQL table type: " sAttribValue
End_Procedure

The sample code above shows the current setting for a given database. The database handle can be obtained via the DF_DATABASE_ID attribute.