MySQL error 1064 syntax but everything seems fine

by

Problem is the word VISIBLE, remove it and it will work.
Index are visible by default.

Your question: “If i remove VISIBLE it works just fine, so why did mysql workbench decided to add visible?”

My answer: The option to mark index invisible is not yet implemented in MariaDB (afaik!).

Update:

The syntax for MariaDB is different, please see this reference: https://jira.mariadb.org/browse/MDEV-7317

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. How can I change MariaDB to MySQL in XAMPP?
  3. How to turn on/off MySQL strict mode in localhost (xampp)?
  4. 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 '0
  5. Trouble with UTF-8 characters; what I see is not what I stored
  6. How to solve “Error: MySQL shutdown unexpectedly”?
  7. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  8. MySQL: Grant **all** privileges on database
  9. Which is faster: multiple single INSERTs or one multiple-row INSERT?
  10. xampp MySQL does not start
  11. How can I access the MySQL command line with XAMPP for Windows?
  12. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  13. MySQL/MariaDB – order by inside subquery
  14. Cast int to varchar
  15. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  16. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  17. How repair corrupt xampp ‘mysql.user’ table?
  18. Higher cardinality column first in an index when involving a range?
  19. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  20. MySQL – SELECT * INTO OUTFILE LOCAL ?
  21. Database corruption with MariaDB : Table doesn’t exist in engine
  22. XAMPP – Error: MySQL shutdown unexpectedly
  23. How to get back Lost phpMyAdmin Password, XAMPP
  24. django cannot connect mysql in docker-compose
  25. Delimiters in MySQL
  26. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  27. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  28. MySQL error 1022 when creating table
  29. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  30. Mysql server does not support 4-byte encoded utf8 characters

Leave a Comment