微软mysql官网_MySQL - Connectors | Microsoft Docs

MySQL

MySQL is an open-source relational database management system. Connect to on-premise MySQL database to read and write data.

In this article

This connector is available in the following products and regions:

Service

Class

Regions

Logic Apps

Standard

All Logic Apps regions except the following:

-   Azure China regions

Power Automate

Premium

All Power Automate regions except the following:

-   US Government (GCC High)

-   China Cloud operated by 21Vianet

Power Apps

Premium

All Power Apps regions except the following:

-   US Government (GCC High)

-   China Cloud operated by 21Vianet

Prerequisites

MySQL connector requires Connector/Net 6.6.5+ to be installed. To install Connector/Net, go to release page and download the relevant release. The provider is 32-bit and built with platform ANY CPU so it can be used on any architecture (32-bit or 64-bit) of the product where you intent to use the connector. The minimun supported MySQL database version is version 5.1.

Creating a connection

The connector supports the following authentication types:

Required parameters for creating connection.

All regions

Default

Applicable: All regions

Required parameters for creating connection.

Name

Type

Description

Server

string

Specify the MySQL server.

Database Name

string

Specify the MySQL database name.

Authentication Type [Select Basic]

string

Authentication type to connect to your database

Username

securestring

Username credential

Password

securestring

Password credential

Gateway

gatewaySetting

Encrypt Connection

bool

Encrypt Connection

Privacy Setting

string

Privacy Setting

Throttling Limits

Name

Calls

Renewal Period

API calls per connection30060 seconds

Actions

This operation deletes a row from a table.

This operation gets a row from a table.

This operation gets rows from a table.

This operation gets tables from a database.

This operation inserts a new row into a table.

This operation updates an existing row in a table.

Delete row

Operation ID:DeleteItem

This operation deletes a row from a table.

Parameters

Name

Key

Required

Type

Description

Table name

table

True

string

Name of table

Row id

id

True

string

Primary key of the row to delete

Get row

Operation ID:GetItem

This operation gets a row from a table.

Parameters

Name

Key

Required

Type

Description

Table name

table

True

string

Name of MySql table

Row id

id

True

string

Primary key of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows

Operation ID:GetItems

This operation gets rows from a table.

Parameters

Name

Key

Required

Type

Description

Table name

table

True

string

Name of MySql table

Filter Query

$filter

string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).

Order By

$orderby

string

An ODATA orderBy query for specifying the order of entries.

Maximum Get Count

$top

integer

Maximum number of entries to retrieve (default = 512).

Skip Count

$skip

integer

The number of entries to skip (default = 0).

Select Query

$select

string

Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Get tables

Operation ID:GetTables

This operation gets tables from a database.

Returns

Represents a list of tables.

Insert row

Operation ID:PostItem

This operation inserts a new row into a table.

Parameters

Name

Key

Required

Type

Description

Table name

table

True

string

Name of table

Row

item

True

dynamic

Row to insert into the specified table

Returns

The outputs of this operation are dynamic.

Update row

Operation ID:PatchItem

This operation updates an existing row in a table.

Parameters

Name

Key

Required

Type

Description

Table name

table

True

string

Name of table

Row id

id

True

string

Primary key of the row to update

Row

item

True

dynamic

Row with updated values

Returns

The outputs of this operation are dynamic.

Definitions

Table

Represents a table.

Name

Path

Type

Description

Name

Name

string

The name of the table. The name is used at runtime.

DisplayName

DisplayName

string

The display name of the table.

TablesList

Represents a list of tables.

Name

Path

Type

Description

value

value

array of Table

List of Tables