Blueprints MySQL Connector / UE4 | DTMysql plugin instructions

This plugin mainly supports connecting and operating MYSQL database in UE4 blueprint.

1. Database connection 【 Create Mysql 】

‘

Enter:

Host: database IP address

Port: database open port

User: database username

Password: database password

DBName: Specifies the database library name of the connection

Output:

Success: Returns whether the database connection is successful

Error No: The connection error returns the error number, and the success returns 0

Error Msg: Connection error returns error message

2. Operate the database [Execute SQL]

Enter:

SQL: SQL statement to execute, supports SELECT, DELETE, INSERT, UPDATE, CALL. Basically all SQL statements are supported, and the database can be manipulated directly here.
Some knowledge of SQL syntax is required.

Output:

Success: Returns whether the operation was executed successfully

Error No: Error number, returns 0 successfully

Error Msg: Execution error returns error message

Rows: The number of rows of output results after execution

Result: Returns the database result set. If it is a CALL stored procedure or database function, it may return multiple result sets. In this case, [ Add Result ] is required, and add according to the actual return.

3. Result set decomposition

The result set returned by Result is an array of MAP, an array is equal to the information of one row, and the data of this row is stored in a MAP.

You can also use the built-in function of this plugin to convert the output result set to JSON.

在代码插件创建的MySQL Connector - 虚幻引擎商城 (unrealengine.com)