Go to app
Academy
What's new?
Tray UAC
Developer
Connectors
Templates
Help Center
Back
MySQL
Overview
Operations (sample payloads)
Operations
MySQL Operations
Latest version:
3.0
Changelog
Count rows
Counts the number of rows that meet a given set of conditions.
Create or update table from csv
Create or update a table from a CSV file export.
Create or update table with load data
Create or update a table using MySQl LOAD DATA. local_infile global variable must be set to true in your MySQL database. Max file size allowed is 300MB.
Delete rows
Deletes rows in your database based on criteria of your choosing.
Export table as csv
Creates a CSV from a table.
Find rows
Find rows in your database based on criteria of your choosing.
Insert new rows
Insert one or more rows into your MySQL database.
List table fields DDL
List tables DDL
Run SQL query
Execute the specified SQL code on the chosen database
Update rows
Updates rows in your database based on criteria of your choosing.
Previous
Operations (sample payloads)