1.先建一个personal数据库,在MySQL中输入:
create database personal;
2.再建两张表,分别是personal_a和personal_b,然后将数据插到personal_a里。SQL语句为
create table `personal_a` (
`id` varchar (60),
`surname` varchar (60),
`name` varchar (60),
`age` int (10),
`sex` varchar (60));
create table `personal_b` (
`id` varchar (60),
`username` varchar (60),
`age` int (10),
`sex` varchar (60));
insert into `personal_a` (`id`, `surname`, `name`, `age`, `sex`) values('p001','张','三','18','male');
insert into `personal_a` (`id`, `surname`, `name`, `age`, `sex`) values('p002','李','四','19','female');
insert into `personal_a` (`id`, `surname`, `name`, `age`, `sex`) values('p003','王','五','18','female');
insert into `personal_a` (`id`, `surname`, `name`, `age`, `sex`) values('p004','赵','六','20','female');
insert into `personal_a` (`id`, `surname`, `name`, `age`, `sex`) values('p005','孙','七','19','male');
insert into `personal_a` (`id`, `surname`, `name`, `age`, `sex`) values('p006','周','八','21','female');
insert into `personal_a` (`id`, `surname`, `name`, `age`, `sex`) values('p007','吴','九','20','male');
3.数据预览
4. 打开kettle新建一个转换
5.添加表输入控件、JavaScript代码控件、插入/更新控件以及跳连接线
6. 配置表输入
7.在获取SQL查询语句框里面输入查询语句点击预览看数据是否抽取进来
8.双击javascript代码填入以下代码,在字段中添加如下信息
9.配置插入/更新控件
最后点击编辑映射,选择相同的源字段和目标字段之后点击Add