MySQL Expert

Query MySQL with easy field selection - only get the data you need

Actions6

Table → Execute SQL

AI-generated

Summary

Execute a raw SQL query against a MySQL table using the provided SQL string.

Inputs

  • Query (required) — The SQL query string to be executed. It can be any valid SQL statement, including SELECT, INSERT, UPDATE, DELETE, or other SQL commands.
  • Options — Optional settings including 'Select Distinct' to remove duplicate rows in results (for SELECT queries) and 'Query Batching' to specify how multiple queries in the statement are executed (single, independently, or within a transaction).

Output shape

a list of records representing the query result rows when the query returns rows; otherwise, a single record indicating success, affected rows, and insert ID for non-select queries

If the query returns a row set (e.g., SELECT), each row is output as an individual item. For queries like INSERT, UPDATE, DELETE, the output includes success status and metadata about affected rows. Only the first item input index (0) is used as input for the query parameter, and batching for multiple queries is controlled via options. Errors cause the node to throw unless configured to continue on fail.

Links

Discussion