使用蓝图连接MySQL数据库,执行SQL语句或调用存储过程,可以获得多个结果集。
Use blueprints to connect to MySQL databases, execute SQL statements or call stored procedures, and you can get multiple result sets.
插件可以直接执行SQL语句,SELECT,DELETE,INSERT,UPDATE,CALL。
直接操作数据库,并返回相应结果集,并可以把结果集转换为TArray<TMap<FString,FString>>或是Json数据。
Plugins can directly execute SQL statements, SELECT, DELETE, INSERT, UPDATE, CALL.
Directly operate the database, and return the corresponding result set, and can convert the result set into TArray<TMap<FString, FString>> or Json data.
1. Connect Mysql
连接数据库,配置相应数据库信息后,会在后台一直保持连接。
After connecting to the database and configuring the corresponding database information, the connection will always be maintained in the background.
2. Execute SQL
执行数据库语句,也可以调用数据库的存储过程和函数。
Execute database statements, and can also call database stored procedures and functions.