UIPATH mariaDB Insert 오류

UiPath 지침에 따라 mariadb를 잘 설치하고 connect to database 까지 성공적으로 마쳤습니다.
그러나 data를 넣으려는 insert 구문에서 오류가 발생하였습니다.

오류의 내용은 아래와 같습니다.

Insert: ERROR [42000] [ma-3.1.19][10.11.2-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘DEFAULT VALUES’ at line 1

무슨이유 일까요?

Hi @Ilgu_Yong ,
Could you please share your screen short


Can you please show what insert you have used


korea language, 연결 = connect
simple flow, but i can use insert

UiPath version: 23.10
UiPath.database.activityes : 1.7.1
i was tried 1.5.0 ~1.7.1 version but it was not working

I checked several similar symptoms and saw that some were successful by changing Database activities to version 1.4. But that doesn’t seem to be the answer.


Inset actitvity will work only when given excel has the column type and data type exactly matchign with the db


of course. It’s the exact same Excel form. This is not a problem. Thank you for leaving a reply!


is the datatype also same?

can you try with a simple table with only one column and text type in datatable