Error in creating FK

Asked

Viewed 47 times

0

Operation failed: There was an error while Applying the SQL script to the database.

Executing: ALTER TABLE prouni.ies ADD INDEX local_idx (local ASC) VISIBLE; ;

ALTER TABLE prouni.ies

ADD CONSTRAINT local FOREIGN KEY (local) REFERENCES prouni.local (idlocal) ON DELETE NO ACTION ON UPDATE NO ACTION;

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 '' at line 2

SQL Statement: ALTER TABLE prouni.ies ADD INDEX local_idx (local ASC) VISIBLE

mysql-workbench foreign-key

  • Mariadb does not support index visibility attribute. Remove keyword VISIBLE

  • Thanks <3 It worked!

No answers

Browser other questions tagged mysql-workbench foreign-key

You are not signed in. Login or sign up in order to post.