🐬 MySQL
Query and manipulate MySQL databases with SQL.
Overview
Query and manipulate MySQL databases directly from your workflows. Run SELECT queries, insert rows, update records, or delete data using SQL with variable interpolation.
Configuration
- Credential — select a MySQL database credential
- Operation — Execute Query, Insert, Update, or Delete
- SQL Query — your SQL statement with
{{variable}}interpolation - Output Variable — name for storing query results
Accessing Results
{{$json.mysql_result}}— array of result rows{{$json.mysql_result[0].column_name}}— access specific column from first row