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.