Icon

kn_​example_​db_​mysql_​where_​clause

create table in MySQL and create a dynamic WHERE clause with integers and strings

create table in MySQL and create a dynamic WHERE clause with integers and strings

create table in MySQL and create a dynamic WHERE clause with integers and stringshttps://forum.knime.com/t/what-is-wrong-with-my-sql/69211/19?u=mlauber71 SELECT * FROM #table# AS `table`WHERE `ID` IN ($${SID}$$)AND `SOMENUMBER` IN ($${SSOMENUMBER}$$) root123456db_knimemy_table_00read emptymy_table_00db_knime.my_table_00db_knime.my_table_00with data1st create (empty)MySQL tablemy_table_00with "new_id" as primary keynew_idremovedb_knime.my_table_00if existssample_data.txtselect a sampleSOMENUMBERIDSOMENUMBERIDdb_knime.my_table_00with samples dataIDjoin("'",$ID$,"'")sample_data.tableknime://knime.workflow/data/my_database.h2db_knime.my_table_00with samples datamy_table_001st create (empty)MySQL tablemy_table_00with "new_id" as primary keyremovemy_table_00if existsSHUTDOWN COMPACT; MySQL Connector DB Reader DB Table Selector DB Writer DB Reader DB Table Creator Java Snippet(simple) DB Table Remover CSV Reader Partitioning GroupBy GroupBy DB Query Table Rowto Variable Table Rowto Variable Merge Variables DB Reader String Manipulation Table Writer H2 Connector DB Reader DB Writer DB Query DB Table Creator DB Table Remover DB SQL Executor create table in MySQL and create a dynamic WHERE clause with integers and stringshttps://forum.knime.com/t/what-is-wrong-with-my-sql/69211/19?u=mlauber71 SELECT * FROM #table# AS `table`WHERE `ID` IN ($${SID}$$)AND `SOMENUMBER` IN ($${SSOMENUMBER}$$) root123456db_knimemy_table_00read emptymy_table_00db_knime.my_table_00db_knime.my_table_00with data1st create (empty)MySQL tablemy_table_00with "new_id" as primary keynew_idremovedb_knime.my_table_00if existssample_data.txtselect a sampleSOMENUMBERIDSOMENUMBERIDdb_knime.my_table_00with samples dataIDjoin("'",$ID$,"'")sample_data.tableknime://knime.workflow/data/my_database.h2db_knime.my_table_00with samples datamy_table_001st create (empty)MySQL tablemy_table_00with "new_id" as primary keyremovemy_table_00if existsSHUTDOWN COMPACT;MySQL Connector DB Reader DB Table Selector DB Writer DB Reader DB Table Creator Java Snippet(simple) DB Table Remover CSV Reader Partitioning GroupBy GroupBy DB Query Table Rowto Variable Table Rowto Variable Merge Variables DB Reader String Manipulation Table Writer H2 Connector DB Reader DB Writer DB Query DB Table Creator DB Table Remover DB SQL Executor

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: m_lauber
Created at: 2023-01-25
On NodePit since: 2023-06-15
Last update: 2024-05-01
Created with KNIME version: v4.7.4
Tags: mysqlsqldbdatabaseH2

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

Try NodePit Runner!