Icon

测试MySQL连接和数据处理

测试MySQL连接和数据处理

测试MySQL连接和数据处理

连接到韩淑敏的腾讯云MySQL库：
域名：gz-cdb-esmcsxl9.sql.tencentcdb.com
数据库名：
端口：58586
账户：root
读取表：xjdb
过滤部分字段
过滤 民族=汉 和民族=NULL
对民族计数，输出饼图

连接到数据库选择表加载数据Node 4Node 5选择列颜色：民族民族：饼图输出性别统计民族统计出生年份统计从出生日期变为年份颜色：性别性别：饼图输出颜色：年份年份：饼图输出颜色：班级班级：饼图输出出生年份统计Node 25Node 26MySQL Connector DB Table Selector DB Reader Row Filter Row Filter Column Filter Color Manager Pie/Donut Chart Value Counter Value Counter Value Counter String Manipulation Color Manager Pie/Donut Chart Color Manager Pie/Donut Chart Color Manager Pie/Donut Chart Value Counter Concatenate Table to HTML 连接到数据库选择表加载数据Node 4Node 5选择列颜色：民族民族：饼图输出性别统计民族统计出生年份统计从出生日期变为年份颜色：性别性别：饼图输出颜色：年份年份：饼图输出颜色：班级班级：饼图输出出生年份统计Node 25Node 26MySQL Connector DB Table Selector DB Reader Row Filter Row Filter Column Filter Color Manager Pie/Donut Chart Value Counter Value Counter Value Counter String Manipulation Color Manager Pie/Donut Chart Color Manager Pie/Donut Chart Color Manager Pie/Donut Chart Value Counter Concatenate Table to HTML

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: 13871
Created at: 2021-09-20
On NodePit since: 2021-09-20
Last update: 2024-11-23
Created with KNIME version: v4.4.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!