Форум пользователей MySQL

CREATE TABLE currency_rate (
  NBU_ID int(11) NOT NULL DEFAULT 0,
  FULL_NAME varchar(64) NOT NULL DEFAULT '',
  RATE decimal(24, 12) DEFAULT NULL,
  SHORT_NAME varchar(5) NOT NULL DEFAULT '',
  EXCHANGEDATE date NOT NULL
)
ENGINE = CONNECT
`TABLE_TYPE` = MYSQL
CHARACTER SET utf8
COLLATE utf8_unicode_ci
CONNECTION = 'mysql://user:psw@10.1.1.1/db/CURRENCY_RATE'
ROW_FORMAT = DYNAMIC;

SELECT * FROM currency_rate Order BY FULL_NAME;