mysqlmariadblibreoffice-base

View Libreoffice Base queries to mysql

I'm trying to create a table with a primary key from Libreoffice Base connected to MariaDB. A standard table with a primary, autogenerated (incrementing I presume) key.

But it fails with this message:

Error: 1064

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
' PRIMARY KEY  ("ID"))' at line 1

Is there a way to view the query LibereOffice sends?

Solution

  • Enabling logging in the database, to table enabled me to see the faulty query.

    SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';