Syntax\n------\n\nREPAIR [NO_WRITE_TO_BINLOG | LOCAL] VIEW  view_name[, view_name] ... [FROM MYSQL]\n\nDescription\n-----------\n\nThe 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.\n\nBy 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.\n\nBy 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.\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/table-statements/repair-view