#1064 - You have an error in your SQL syntax

The error 1064 occurs due to MySQL version mismatch. Different versions have different reserved words, which, if they are used by a previous version, causes the error to occur.

The simplest and most effective solution for it is the following: when using phpMyadmin (accessible from your Control Panel), select the "compatibility mode" & select the target database version from the drop down box. That's it! You shouldn't get the same error again.

  • 1064, MySQL, mismatch, error, SQL, syntax
  • 0 Пользователи нашли это полезным
Помог ли вам данный ответ?

Связанные статьи

Do you support foreign keys in phpmyadmin?

Foreign keys are supported on all of our packages!

How many mysql user connections do you allow (at the same time)?

Our servers are set to use up to 15 simultaneous MySQL connections for one MySQL user at the same...

MySQL timeout errors

If you experience MySQL timeouts, it's possible you are using heavy or very long MySQL queries....

How to import/export database?

To import/export a MySQL database you need to follow these simple steps: - If you want to import...

How can I modify database charset?

You can modify database charset using phpmyadmin at any time. Simply select the database you want...