CREATE SERVER fedlink
FOREIGN DATA WRAPPER mysql
OPTIONS (USER ‘root’, PASSWORD ‘pwd@2192432’, HOST ‘123.123.123.123’, PORT 3306, DATABASE ‘test’);
然后创建表的时候:
CREATE TABLE user2
(id
varchar(255) NOT NULL COMMENT ‘id’,code
varchar(255) DEFAULT NULL COMMENT ‘代码’,
PRIMARY KEY (id
),
UNIQUE KEY upk_user_id
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT=‘用户表’
ENGINE=FEDERATED CONNECTION = ‘fedlink/user2’;