MySQL Components

6 components available

Code Download v2.1.0
MySQL database.

Changelog

9 versions
v2.1.0 Latest
  • Added test() (Flow Test Mode) to all triggers: NewRow, UpdatedRow, DeletedRow, WatchRows.
v2.0.3
  • Added output examples to component schemas.
v2.0.2
  • UpdatedRow: declare detectOnStop in properties.schema.properties so the inspector input reaches the trigger.
v2.0.1
  • Reduced icon size for better performance.
v2.0.0
  • Breaking change: Improve security by restricting all SQL queries to SELECT/WITH statements only and implementing parameterized queries.
v1.0.3
  • Add catch and log errors while processing individual rows
v1.0.2
  • Fix Query component output
v1.0.1
  • Fix ListTables component
  • Fix Query component
v1.0.0
  • Initial version

Authentication

TypeDetails
API Key
User (text)
Database User
Host (text)
Database Host
Port (text)
Database Port
Database (text)
Name of your database
Password (password)
Password

Triggers

4
Deleted Row icon

Deleted Row

Watch for deleted rows in your MySQL database.
New Row icon

New Row

Watch for new rows in your MySQL database.
Updated Row icon

Updated Row

Watch for updated rows in your MySQL database.
Watch Rows icon

Watch Rows

Watch for new and updated rows in your MySQL database for an arbitrary query.

Actions

2
Query icon

Query

Query your MySQL database.
List Tables icon

List Tables

List all non-system tables in your MySQL database.