ENGINE = CONNECT

CREATE TABLE pult_boxmdu (

  id int(11) NOT NULL,

  region_ID int(11) NOT NULL,

  PRIMARY KEY (id)

)

ENGINE = CONNECT,

TABLE_TYPE = ODBC,

TABNAME = 'pult_boxmdu',

READONLY = 1,

CHARACTER SET cp1251,

COLLATE cp1251_ukrainian_ci,

CONNECTION = 'DSN=Odyssey';

run SELECT id, region_ID FROM pult_boxmdu;

OUT:

id	region_ID

14	3

8	3

26	3

712	2

22	3

SELECT region_ID FROM pult_boxmdu;

region_ID

0

0

0

0

0