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
regards,

@Ilgu_Yong

Can you please show what insert you have used

Cheers


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.

@Ilgu_Yong

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

cheers

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

@Ilgu_Yong

is the datatype also same?

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

cheers