Why does the mysql Workbench always throw me an error when I synchronize tables?

0

With the latest version of mysql workbench, I have only problems. I create two tables, one using an n: n relation, I synchronize it and it always ends with the same message "ERROR: 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 '"

And this error happens to me only with the latest version of mysql workbench, because with an older one, it does not happen to me. Use Xampp with mariaDB.

    
asked by CHRISTIAN MARCELO HERRERA ROJA 24.10.2018 в 06:08
source

1 answer

0

As it says in this documentation the error happens for several things: link

USE WORDS RESERVED

Each version of MySQL has its own list of reserved words. These are words that are used for specific purposes or perform specific functions within the MySQL engine. If you try to use one of these reserved words, you will receive the error.

LOST DATA Sometimes there is a lack of data in the database. This can cause problems when this data is required for a query. For example, if you build a database that requires an ID number for each student, it is reasonable to assume that a query will be constructed to obtain a student record with that number TYPOGRAPHICAL ERROR OF THE COMMANDS One of the most common causes of error 1064 is when a SQL statement uses a poorly written command. OBSOLETE COMMANDS Some commands that were disused (programmed to be deleted but still allowed for a period of time) eventually become obsolete. This means that the command is no longer valid in the SQL statement.

This last one is probably yours since you say that in a past version it did not happen to you. In the link that I passed you there are possible solutions for each of the cases. Greetings.

    
answered by 24.10.2018 в 06:46