数据转换工具 Kettle demo

打开 kettle

• 打开data-integration所在文件目录
• 双击Spoon.bat

打开数据库

双击 mysql-5.6.24-win32\bin 目录下的 mysqld.exe

查看任务管理器是否有 mysqld.exe ，有即启动成功了。

打开mysqlfront连接数据库

kettle打开书编写好的

查询sql

<code>SELECT DATE_FORMAT(riqi,'%Y-%m-%d') as '日期',wuliao as '物料',liebie as '类别',guige as '规格',pinpai as '品牌',danwei as '单位',
hanshuidanjia as '含税单价',shuliang as '数量',danjia as '单价',jine as '金额',gonghuoshang as '供应商',beizhu as '备注'
FROM demo where gonghuoshang like '%新兴县盛捷气体有限公司%' and wuliao like '%二氧化碳%' and riqi >= '20160901' and riqi <= '20170131'; </code>