Open liviuconcioiu opened 1 year ago
I believe the two queries do execute, can you post a documentation link for this sort of query ?
I believe the two queries do execute, can you post a documentation link for this sort of query ?
https://mariadb.com/kb/en/check-table/ https://mariadb.com/kb/en/alter-table/
https://dev.mysql.com/doc/refman/8.0/en/check-table.html https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
About the CHECK TABLE statement:
CHECK TABLE
is available at least since MySQL 5.0: https://web.archive.org/web/20160324160726/https://dev.mysql.com/doc/refman/5.0/en/check-table.htmlAbout the ALTER TABLE … FORCE statement:
TABLE_OPTIONS
on AlterStatement
class, so it is not managed yet.
CHECK TABLE `table` FOR UPGRADE;
will give two errors.FOR
)UPGRADE
)ALTER TABLE `table` FORCE;
will give one error.;
)https://user-images.githubusercontent.com/25424343/222978476-b5959513-be8d-4b49-af58-9b28121505f6.mp4