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