Icon

DB SQL - H2 Database, create database and additional tables

<p>DB SQL - H2 Database, create database and additional tables</p>

URL: Medium: KNIME, Databases and SQL https://medium.com/p/273e27c9702a
URL: Practicing with Traditional Databases https://hub.knime.com/-/spaces/-/~DgfgZ8jjSOK6s1bF/current-state/
URL: DB SQL - H2 Database, create database and additional tables - KNIME Forum (77916) https://forum.knime.com/t/table-transfer/77916/9?u=mlauber71
URL: KNIME Database Extension Guide https://docs.knime.com/latest/db_extension_guide/index.html#intro
URL: The use of the Modern UI DB Nodes https://forum.knime.com/t/db-table-structure-creator-how-do-i-change-the-column-type-settings/91231/2?u=mlauber71

DB SQL - H2 Database, create database and additional tables

https://forum.knime.com/t/table-transfer/77916/9?u=mlauber71

KNIME, Databases and SQL

https://medium.com/p/273e27c9702a

Create the structure of the database (empty)

Insert the data into the database

Practicing with Traditional Databases

https://hub.knime.com/s/DgfgZ8jjSOK6s1bF

Create the structure of the database (empty)

Insert the data into the database

The use of the Modern UI DB Nodes

https://forum.knime.com/t/db-table-structure-creator-how-do-i-change-the-column-type-settings/91231/2?u=mlauber71

SELECT * FROM #table# AS "t2"WHERE "Counter" > 25
DB Query
my_table_005APPEND
DB Writer (DB Data)
my_table_100
DB Table Deleter
insert therest of the dataset
DB Row Inserter
my_table_100select the table you want.Will appear as #table# in the'brown' database nodes
DB Table Selector
my_table_100string as longvarchar
DB Table Structure Creator
my_table_001string as longvarchar
DB Table Creator (deprecated)
add primary key
DB SQL Executor
SCRIPT NODATA TABLE "PUBLIC"."my_table_100";Check the structure of the table
DB Query Reader
resetthis is a databasein memory just to show how this could work
H2 Connector
INFORMATION_SCHEMA.COLUMNS
DB Query Reader
SCRIPT NODATA TABLE "PUBLIC"."my_table_100";
DB Query Reader
just get a DBconnection here
DB Connection Extractor
insert therest of the dataset
DB Insert (deprecated)
my_table_005CREATE
DB Writer (DB Data)
my_table_001select the table you want.Will appear as #table# in the'brown' database nodes
DB Table Selector (deprecated)
TRUNCATE TABLE "PUBLIC"."my_table_100"
DB SQL Executor
SELECT * FROM #table# AS "t2"WHERE "Counter" > 25
DB Query
my_table_005APPEND
DB Writer (DB Data)
SELECT * FROM #table# AS "t1"WHERE "Counter" <= 25
DB Query
my_table_105CREATE
DB Writer (DB Data)
https://hub.knime.com/-/spaces/-/~4-Nz2crmY1OvrH_M/current-state/
Create Dummy Data
my_table_001
DB Table Deleter
just get a DBconnection here
DB Connection Extractor
SELECT * FROM #table# AS "t1"WHERE "Counter" <= 25
DB Query

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: 2024-03-18
On NodePit since: 2024-03-19
Last update: 2026-01-30
Created with KNIME version: v5.9.0
Tags: DBSQLdatabaseH2Primary Key

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

Try NodePit Runner!