Check and correct a view's algorithm. This statement is primarily used by upgrade scripts to ensure view definitions are compatible.
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 , 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 and will be . 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