Kettle8.2èæ¬ç»ä»¶ä¹SQLèæ¬
-
- ä¸ãç¸å ³è¯´æ
- äºã设计转æ¢
- ä¸ã转æ¢é ç½®
- åãè¿è¡è½¬æ¢
- äºãç»ææ¥ç
ä¸ãç¸å ³è¯´æ
-
SQLèæ¬ç»ä»¶è¯´æï¼
æ§è¡SQLèæ¬å¯ä»¥æ§è¡ä¸ä¸ªupdateè¯å¥ï¼ç¨æ¥æ´æ°æ个表ä¸çæ°æ®ã
-
éæ±è¯´æï¼
ä»æ°æ®åºè¡¨t_sys_usersä¸è·åææçæ°æ®ï¼æageçå¼é½æ´æ¹ä¸º18ã
- æµè¯æ°æ®æºå¦ä¸ï¼è¯»è
éè¦å
å¨MySQLä¸æ§è¡å¦ä¸SQLè¯å¥åå§åæ°æ®
DROP TABLE IF EXISTS `t_sys_user`; CREATE TABLE `t_sys_user` ( `id` int(11) DEFAULT NULL, `name` tinytext COLLATE utf8mb4_unicode_ci, `age` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*Data for the table `t_sys_user` */ insert into `t_sys_user`(`id`,`name`,`age`) values (1,'ä¹å³°',22),(5,'huge',22),(6,'zhoujielun',24),(7,'zhangjie',21),(8,'santy',26),(9,'suben',14),(10,'æå°é¾',100),(11,'æ«å°å§',120),(12,'é¿ç´«',18),(13,'é¿ç ',18),(14,'çè¯å«£',18),(15,'天山童姥',100);
äºã设计转æ¢
- è¾å ¥ï¼è¡¨ç¤ºè¾å ¥
- èæ¬ï¼SQLèæ¬
ä¸ã转æ¢é ç½®
- Step1ï¼è¡¨è¾å
¥ç»ä»¶é
ç½®
- åå»ç»ä»¶ï¼åä¸æ¥éª¤å称ç
- ç¸å ³é ç½®å¦ä¸æ示ï¼
- Step2ï¼SQLèæ¬ç»ä»¶é
ç½®
- åå»æå¼ï¼è®¾ç½®æ¥éª¤å称
- é 置信æ¯ï¼å¦ä¸ï¼
-
Step3ï¼ä¿å转æ¢
ä¸è¿°é 置好åï¼ç¹å»ç¡®å®å³å¯ï¼
åãè¿è¡è½¬æ¢
- ç¹å»è¿è¡æé®ï¼æåè¿è¡å¦ä¸ï¼
äºãç»ææ¥ç
- å°æ°æ®åºè¡¨t_sys_userä¸æ¥çç»æ