Vidyalelo
MySQL · Q692

MySQL

Programming · MySQL · question 692

Q692

A procedure that involves REPAIR TABLE with the USE_FRM option must be done before upgrading.

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
This question asks about REPAIR TABLE in MySQL and its relation to upgrading your MySQL version.
REPAIR TABLE is used to fix errors in your database tables.
The USE_FRM option tells MySQL to use the table's .frm file (which contains the table structure) to help with the repair.
The answer:
While it's good practice to repair tables before upgrading, it's not mandatory.
So the answer is Option B: False.
You can upgrade even if you haven't used REPAIR TABLE with USE_FRM.
However, running REPAIR TABLE can help ensure your tables are in good shape before upgrading.