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
Mariadb does not support index visibility attribute. Remove keyword
VISIBLE– Augusto Vasques
Thanks <3 It worked!
– Igor gomes