Insert: ERROR [: MySQL][ODBC 8.1(a) Driver][mysqld-8.1.0]You have an error elena na that corresponds to your MySQL server version for the right syntax to use near DEFAULT VALUES’ at line 1

[Palaniyappan (Palaniyappan P)]

Hi

Check this knowledge base from UiPath

Database Insert Activity Is Failing

Why error [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.23] is thrown. 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 while using Database insert activity? The possible cause of the issue is the compatibility between Driver and SQL Database version. So, please make sure that the driver installed is compatible with SQL database version. Refer the Microsoft JDBC Driver For SQL…

Cause : The possible cause of the issue is the compatibility between Driver and SQL Database version. So, please make sure that the driver installed is compatible with SQL database version

Some relevant forum post as well for your reference

Read Range - INSERT db Error Unexplained

Hi to all, today, unexpectedly I get an error trying to insert a table on DB. An operation that I generally do normally. The error I see is this: “Insert: ERROR [42000] [MySQL][ODBC 5.3(w) Driver][mysqld-8.0.22]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” The start begins by reading an xlsx file. File has header columns with no spaces. The data in the columns is alphanumeri…

Cheers @nabisab.18