本插件主要是支持在UE蓝图中连接和操作MYSQL数据库。
1. 数据库连接 【 Connect MySql 】

输入:
Host:数据库IP地址
Port: 数据库开放端口
User: 数据库用户名
Password:数据库密码
DBName:指定连接的数据库库名
输出:
Success:返回数据库是否连接成功
Error No: 连接错误返回错误编号,成功返回0
Error Msg:连接错误返回错误信息
2. 操作数据库 【 Execute SQL 】

输入:
SQL: 执行的SQL语句,支持 SELECT, DELETE, INSERT, UPDATE, CALL。 基本所有的SQL语句都是支持的,可以直接在这里操作数据库。
需要一定的SQL语法知识掌握,可以参考 SQL 语法 | 菜鸟教程 (runoob.com)
输出:
Success: 返回操作是否执行成功
Error No:错误编号,成功返回0
Error Msg: 执行错误返回错误信息
Rows: 执行后输出结果行数
Result:返回数据库结果集,如果是CALL存储过程或者数据库函数则可能返回多个结果集,这样的话就需要 [ Add Result ], 根据实际返回添加
3. 结果集分解
Result 返回的结果集为 一个MAP的数组,一个数组等于一行的信息,这一行的数据保存在一个MAP中。
也可以使用本插件自带功能,把输出结果集转换为JSON。
Good afternoon I bought your database connection plugin, UE 5.4. When compiling a project on Linux, an error occurs:
UATHelper: Packaging (Linux): [368/968] Compile viosocket.cc
UATHelper: Packaging (Linux): D:\Plastic\Plugins\DTMysql\Source\ThirdParty\DTMysqlLib\Private\vio\viosocket.cc(280,1): error: non-void function does not return a value in all control paths [-Werror,-Wreturn-type]
UATHelper: Packaging (Linux): }
UATHelper: Packaging (Linux): ^
UATHelper: Packaging (Linux): 1 error generated.
PackagingResults: Error: non-void function does not return a value in all control paths [-Werror,-Wreturn-type]
UATHelper: Packaging (Linux): [369/968] Compile fse_compress.c
How can I fix it and what could it be related to?
Can only be developed on Windows platform.
Linux distribution package needs to be packaged on Windows.
支持多线程吗?支持在一个节点上运行多条语句吗?
单线程操作, 一个一个的执行
UATHelper: 打包 (Windows): [19/20] Link [x64] MysqlTest0609.exe
UATHelper: 打包 (Windows): ���ڴ����� E:\Epic\UE_5.2\YsProject\0609MysqlTest\Binaries\Win64\MysqlTest0609.lib �Ͷ��� E:\Epic\UE_5.2\YsProject\0609MysqlTest\Binaries\Win64\MysqlTest0609.exp
LogSlate: Took 0.008001 seconds to synchronously load lazily loaded font ‘../../../Engine/Content/Slate/Fonts/NotoNaskhArabicUI-Regular.ttf’ (144K)
LogSlate: Last resort fallback font was requested. Font: ‘../../../Engine/Content/Slate/Fonts/DroidSansFallback.ttf’, Character: ‘Ͷ (U+0376)’
UATHelper: 打包 (Windows): charset.cc.obj : error LNK2019: ���������ⲿ���� __std_init_once_link_alternate_names_and_abort������ “void __cdecl std::call_once(struct std::once_flag &,void (__cdecl&)(void))” (??$call_once@A6AXXZ$$V@std@@YAXAEAUonce_flag@0@A6AXXZ@Z) �������˸÷���
LogSlate: Took 0.010975 seconds to synchronously load lazily loaded font ‘../../../Engine/Content/SlateDebug/Fonts/LastResort.ttf’ (5269K)
UATHelper: 打包 (Windows): my_time.cc.obj : error LNK2019: ���������ⲿ���� __std_max_element_1������ “unsigned char const * __cdecl __std_max_element(unsigned char const *,unsigned char const *)” (??$__std_max_element@$$CBE@@YAPEBEPEBE0@Z) �������˸÷���
UATHelper: 打包 (Windows): E:\Epic\UE_5.2\YsProject\0609MysqlTest\Binaries\Win64\MysqlTest0609.exe : fatal error LNK1120: 2 �����������ⲿ����
UATHelper: 打包 (Windows): [20/20] WriteMetadata MysqlTest0609.target cancelled
UATHelper: 打包 (Windows): Took 35.2452854s to run dotnet.exe, ExitCode=6
UATHelper: 打包 (Windows): UnrealBuildTool failed. See log for more details. (C:\Users\15852\AppData\Roaming\Unreal Engine\AutomationTool\Logs\E+Epic+UE_5.2\UBT-MysqlTest0609-Win64-Development.txt)
UATHelper: 打包 (Windows): AutomationTool executed for 0h 0m 39s
UATHelper: 打包 (Windows): AutomationTool exiting with ExitCode=6 (6)
UATHelper: 打包 (Windows): BUILD FAILED
PackagingResults: Error: Unknown Error
LogDerivedDataCache: C:/Users/15852/AppData/Local/UnrealEngine/Common/DerivedDataCache: Maintenance finished in +00:00:13.235 and deleted 1 files with total size 0 MiB and 1 empty folders. Scanned 7513 files in 9560 folders with total size 298 MiB.
蓝图新建一个第三人称项目,使用插件后打包失败
加QQ 45141961