Heliont MySQLInstall

Summary

Executes a custom SQL query against a MySQL database with support for parameterized queries, batching modes, and detailed debugging output.

Inputs

• input — Items that flow into the node. Depending on the Query Batching setting, the node will run a single query for all items, one query per item, or all queries in a single transaction.

Output shape

main

The node has two output branches: 'No Result' and 'Results'.

Examples

Example 1: Selecting rows

Set Query to SELECT id, name FROM users WHERE active = $1, provide Query Parameters as true, and keep Query Batching on Single Query. The node returns the matching rows in the Results output.