MySQL Error 1064: How to Fix Syntax Discrepancies in MariaDB?

MySQL Error 1064: Syntactic Discrepancy

When executing commands in MySQL Workbench, users may encounter Error 1064, indicating a syntax error. This error can arise when using XAMPP, which natively employs MariaDB instead of MySQL.

Possible Solutions:

• Remove the VISIBLE Attribute: The syntax used in the given query includes the VISIBLE attribute while adding an index. However, this attribute is not supported in MariaDB. Removing VISIBLE will resolve the error.
• Check MariaDB Syntax: Since XAMPP uses MariaDB, it's crucial to adhere to its specific syntax. For instance, in the example query, the command to add a foreign key should be modified to match MariaDB syntax, as outlined in the following reference: https://jira.mariadb.org/browse/MDEV-7317.

The above is the detailed content of MySQL Error 1064: How to Fix Syntax Discrepancies in MariaDB?. For more information, please follow other related articles on the PHP Chinese website!