Getting error while connecting to mysql database from UI path

Help Studio
1

System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 8.0(a) Driver][mysqld-5.7.36]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DEFAULT VALUES’ at line 1 at UiPath.Database.Activities.InsertDataTable.HandleException(Exception ex, Boolean continueOnError)

Getting this error while inserting data into the database from UI Path.
The database connection is working, getting issue only during insert.

Appreciate you help in advance.

2

Hi @Hemant_Deshmukh

I think This is a syntax error.
Check your Query

Hope it helps!!

3

Hi @Hemant_Deshmukh

Review the syntax of your SQL query. Ensure that the “DEFAULT VALUES” clause is used correctly and in a valid context. It’s possible that the placement of this clause or its usage in your query is causing the error.

Regards

4

This is a GPT Ans. but Not Solve