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
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. |
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. |
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. |
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. |
Parameter |
Description |
---|---|
Statement |
Enter the native SQL statement for operating the database.
|
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot