MySQL

The MySQL connector is used to connect to the MySQL database by establishing and maintaining the connection between applications and the database, and managing data transmission.

MySQL is a popular, open-source relational database widely used as the backend of web applications. It supports multiple operating systems, such as Windows, Linux, Unix, and macOS X. MySQL features high performance, reliability, and flexibility, and is popular among enterprises and developers.
The default MySQL port number is 3306. The administrator can change the port number as required. MySQL supports multiple storage engines, including InnoDB, MyISAM, and MEMORY. Each storage engine has its own pros and cons and can be configured flexibly.

Creating a MySQL Connection

Log in to the new ROMA Connect console.
In the navigation pane on the left, choose Connector. On the page displayed, click New Connection.
Select the MySQL connector.

In the dialog box displayed, configure the connector and click OK.

Parameter	Description
Name	Enter the connector instance name.
Region	Select a region.
Project	Select a project.
Instance	Select an instance for subsequent connectivity verification.
Connection and Security	Select the connection mode for the database. Currently, the Default mode is supported.
IP Address	Enter the IP address of the database.
Port	Enter the port number to which the database is connected.
Database Name	Enter the name of the database to be connected.
Username	Enter the username used to connect to the database.
Password	Enter the password used to connect to the database.
Description	Enter the description of the connector to identify it.

Action

Obtaining records
Adding records
Updating records
Deleting records
Custom SQL

Configuration Parameters

**Table 1** Obtaining records
Parameter	Description
Table Name	Enter the name of the data table to be queried.
Column Name	Enter the column name of the data table.
Field Name	Enter the fields to be queried. Separate multiple fields with commas (,).
WHERE Condition	Enter the conditions for the queried data.
Order By Field	Enter the sorting fields of the returned result.
Limits	Enter the number of records on each page in the returned result.
Offset	Enter the offset of the pagination query.

**Table 2** Adding records
Parameter	Description
Table Name	Enter the name of the table where data will be inserted.
Data to Insert	Enter the value of the target field in the insert operation.

**Table 3** Updating records
Parameter	Description
Table Name	Enter the name of the table where data will be updated.
Data to Update	Enter the value of the target field in the update operation.
WHERE Condition	Enter the conditions for the data to be updated.

**Table 4** Deleting records
Parameter	Description
Table Name	Enter the name of the table where data will be deleted.
WHERE Condition	Specifies the conditions for the data to be deleted.

**Table 5** Custom SQL
Parameter	Description
Statement	Enter the native SQL statement for operating the database. Statements display all your inputs as plain text. Do not include sensitive information. Be careful when using non-query statements such as drop and truncate.