一 Kettle下载
版本为:7.1.0.0-12
已解决Mysql数据库驱动不匹配问题。驱动包版本为mysql-connector-java-5.1.37-bin.jar。
具体问题:
Couldn't get field info from [select * from user]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
二Kettle输入、输出表数据乱码解决
set names utf8;
![](https://i-blog.csdnimg.cn/blog_migrate/f9026af4aba3ea6eb7cca0383b5746bf.png)
characterEncoding utf8
![](https://i-blog.csdnimg.cn/blog_migrate/986a817232c15dc041fafe6adc15ff31.png)