<?xml version="1.0" encoding="UTF-8"?> <transfer> <tableMap> <!-- 源数据表 或者说是数据来源来--> <sourceTable>cust_gather_type_31</sourceTable> <sourceCharset>utf8</sourceCharset> <!-- 目标表或者说是数据流向表 --> <targetDataBase>daily_login_log</targetDataBase> <targetTable>login_log</targetTable> <targetEngine>MyISAM</targetEngine> <targetCharset>utf8</targetCharset> <!-- 目标表的索引列表 --> <targetTndexes> <!-- 建立索引的值,如:PRIMARY KEY (`id`) 或者 KEY `d` (`name`) --> <index></index> </targetTndexes> <columnMap> <column> <sourceColumn>data1</sourceColumn> <targetColumn>update_time</targetColumn> <type>varchar</type> <length>14</length> <!-- 是否为自增长、值为true或1,false、0和放空--> <auto_increment></auto_increment> <!-- 是否为有符号类型,当在数值类型时有效 ,值为true或1,false、0和放空--> <unsigned></unsigned> <!-- 默认值 --> <defult></defult> <comment></comment> </column> <column> <sourceColumn>district_id</sourceColumn> <targetColumn>dist_id</targetColumn> <type>int</type> <unsigned>true</unsigned> <length>5</length> </column> <column> <sourceColumn>district_id</sourceColumn> <targetColumn>dist_id</targetColumn> <type>int</type> <unsigned>true</unsigned> <length>5</length> </column> </columnMap> </tableMap> </transfer>
http://www.ibm.com/developerworks/cn/xml/x-dom4j.html