MySQL
MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.
Using MySQL?
Easy connect MySQL with other services: CRM, webinars, email campaigns, calls, chat bots, Google Sheets, and other 150+ services
Connect MySQL with other services in few minutes
Easy integrate MySQL and connect realtime online data sync with other services: Pipedrive, WebinarJam, GetResponse, Google Sheets, SMS or voice calls, messengers and many more.
Templates for MySQL integration
It is much easier to configure MySQL's connection to other services using ready-made script templates. You can also create a new custom workflow using our visual constructor.
MySQL's triggers and actions
- No triggers available for this connector
Custom query
-
Execute query with data set return
Parameters:
- Connection string, String
- Custom query, String
Returns:
- result, Array [Object]
-
Execute query with scalar return
Parameters:
- Connection string, String
- Custom query, String
Returns:
- result, Object
-
Delete items from table
Parameters:
- Connection string, String
- Table name, String
- Filter, String
Returns:
- rowsAffected, Integer
-
Insert single row into table
Parameters:
- Connection string, String
- Table name, String
- Item to insert, Object
- Enable identity insert, Boolean
- Identity field name, String
- Result format, Integer
Returns:
- updatedObject, Object
- rowsAffected, Integer
-
Insert items into table
Parameters:
- Connection string, String
- Table name, String
- Items to insert, Array [Object]
- Identity field name, String
- Enable identity insert, Boolean
Returns:
- rowsAffected, Integer
-
Save items into table (using INSERT or UPDATE)
Parameters:
- Connection string, String
- Table name, String
- Items to insert, Array [Object]
- Identity field name, String
- Enable identity insert, Boolean
- Compare by fields, Array [String]
Returns:
- rowsAffected, Integer
-
Select data from table
Parameters:
- Connection string, String
- Table name, String
- Fields, String
- Filter, String
- Sort by, String
- Result format, Integer
Returns:
- data, Array [Object]
- count, Integer
-
GETUpdate item
Update single row in table
Parameters:
- Connection string, String
- Table name, String
- Identity field name, String
- Item to update, Object
- Result format, Integer
Returns:
- updatedItem, Object
-
Update items in table
Parameters:
- Connection string, String
- Table name, String
- Update functions (e.g. Count=Count+2, Name='Test'), String
- Filter, String
Returns:
- rowsAffected, Integer
-
GETCreate table
Create new table
Parameters:
- Connection string, String
- Table name, String
- Fields description, Array [Object]
Returns:
- tableMetadata, Object
- success, Boolean
- reason, String
-
GETDelete table
Delete table
Parameters:
- Connection string, String
- Table name, String
Returns:
- success, Boolean
- reason, String
-
GETGet table
Returns table metadata by name
Parameters:
- Connection string, String
- Table name, String
Returns:
- tableName, String
- fieldsMetadata, Array [Object]
-
GETTables list
Get tables list for database
Parameters:
- Connection string, String
Returns:
- tablesMetadata, Array [Object]
- databaseName, String
- success, Boolean
- reason, String
-
Execute procedure and returns array of results
Parameters:
- Connection string, String
- Procedure name, String
- Parameters, Array [Object]
Returns:
- isSuccess, Boolean
- result, Object
-
Execute stored procedure with single return value
Parameters:
- Connection string, String
- Procedure name, String
- Parameters, Array [Object]
Returns:
- isSuccess, Boolean
- result, Object
-
Execute stored procedure without return value
Parameters:
- Connection string, String
- Procedure name, String
- Parameters, Array [Object]
Returns:
- isSuccess, Boolean
- result, Object
Data operations
Database management
Stored procedures
Start your journey in world of limitless automation for free
You can test all features for free during 30-days trial period, no credit card required