Organizational Research By

Surprising Reserch Topic

command with which MySQL table can be repaired?



asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes
7 views



Related Hot Questions

1 Answer

0 votes

The command syntax with which mysql table can be repaired is as follows:

REPAIR TABLE tablename;
REPAIR TABLE tablename QUICK;
REPAIR TABLE tablename EXTENDED;
The command will just do as it says repair a specified table, but if QUICK or EXTENDED is used then the meaning of it changes. In case of QUICK it will repair only the index tree, whereas in case of EXTENDED it will create index row by row and repair it.
 
answered Sep 13, 2013 by rajesh
edited Sep 12, 2013

...