MySQL

UPDATE:2023-06-13

On this page

ODBC

  1. Driver
  2. DSN Setting
    Windows : ODBC data source administrator

Method

  1. [System]Get TableName(Use sequential numbers instead.)
    SELECT TABLE_NAME,TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES
  2. [System]Get FieldName and FieldType
    SELECT ORDINAL_POSITION,COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='<Table Name>'