REPAIR [NO_WRITE_TO_BINLOG | LOCAL] VIEW view_name[, view_name] ... [FROM MYSQL]
The REPAIR VIEW
statement checks whether the view algorithm is correct. It is run as part of mariadb-upgrade, and should not normally be required in regular use.
By default it corrects the checksum and if necessary adds the mariadb-version field. If the optional FROM MYSQL
clause is used, and no mariadb-version field is present, the MERGE
and TEMPTABLE
algorithms are toggled.
By default, REPAIR VIEW
statements are written to the binary log and will be replicated. The NO_WRITE_TO_BINLOG
keyword (LOCAL
is an alias) will ensure the statement is not written to the binary log.
This page is licensed: CC BY-SA / Gnu FDL