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
  • Data operations
  • 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
  • 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
  • Database management
  • Create new table

    Parameters:

      • Connection string, String
        • Table name, String
        • Fields description, Array [Object]

    Returns:

    • tableMetadata, Object
    • success, Boolean
    • reason, String
  • Delete table

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • success, Boolean
    • reason, String
  • Returns table metadata by name

    Parameters:

    • Connection string, String
    • Table name, String

    Returns:

    • tableName, String
    • fieldsMetadata, Array [Object]
  • Get tables list for database

    Parameters:

    • Connection string, String

    Returns:

    • tablesMetadata, Array [Object]
    • databaseName, String
    • success, Boolean
    • reason, String
  • Stored procedures
  • 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
 

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