All integrationsDatabases
MySQL
Query and change data in MySQL and MariaDB, including Amazon RDS, Cloud SQL and PlanetScale: run SQL with safe parameters; find, count, select, insert, upsert, update and delete rows without writing SQL; create and drop tables; call procedures; look up databases, tables, columns and indexes; and start a workflow when a row is added or changed.
- actions
- 20
- triggers
- 2
Triggers
Start a workflow when something happens in MySQL.
- New row (MySQL)Triggers when a row is added to a MySQL table, found by checking for rows past the highest id (or other ever-growing column) seen so far. Rows already in the table don't trigger it.
- New or updated row (MySQL)Triggers when a row is added to or changed in a MySQL table, found by checking a column the table sets to the current time on every change, such as updated_at. Rows as they were before the workflow was turned on don't trigger it.
Actions
Steps a workflow can run in MySQL.
- Run queryRun a SQL query and return its rows. Use %(name)s placeholders with 'Parameters' for any value that comes from data. The user's privileges decide what it can touch.
- Run statementRun an INSERT, UPDATE, DELETE or DDL statement (such as CREATE TABLE) and get the number of rows it changed. Use %(name)s placeholders with 'Parameters' for values.
- Select rowsRead rows from a table without writing SQL: choose columns, match on values, sort and page. A limit always applies.
- Insert rowAdd one row to a table and get back its new AUTO_INCREMENT id, if the table has one.
- Insert rowsAdd up to 1,000 rows in one go, all or nothing. A column missing from a row is stored as null.
- Update rowsChange columns on the rows matching the given values. At least one 'Match rows where' entry is required. Rows already holding the new values are not counted as changed.
- Delete rowsRemove the rows matching the given values. At least one 'Match rows where' entry is required.
- List tablesThe tables in the connected database or another one, optionally with views.
- Describe tableA table's or view's columns in order, with type, nullability and default, and its primary key.
- Upsert rowUpdate the row with the same key, or insert it if there is none. MySQL updates whichever row shares the table's primary key or any unique key with the new one; 'Match on columns' names columns that must be in the values and are left as they are on update. It defaults to the primary key.
- Count rowsHow many rows in a table match the given values, or all of its rows when none are given.
- Find rowThe first row matching the given values, or found: false when there is none, so a later step can branch on it. Without a sort column, which matching row comes back is up to the database.
- Create tableCreate a table from a list of columns. By default an existing table of that name is left alone.
- Drop tableDelete a table and every row in it. This cannot be undone.
- List databasesThe databases on the server the user can see, leaving out MySQL's own.
- List viewsThe views the user can see, in the connected database or another one.
- List indexesA table's indexes with their columns in key order, and which is the primary key.
- List proceduresThe stored procedures and functions the user can see, optionally with each one's parameters.
- Call procedureCall a stored procedure or function with arguments and get back every result set it produces. A function's return value comes back as a row with a result column.
- Get server infoThe server's product and version, the database and the user signed in. The quickest way to check the connection works.
No actions match that.
Automate MySQL with Lodol.
Connect MySQL and ask your AI for your first workflow.
Free plan, no credit card