Home > DeveloperSection > Interviews > How can we repair a MySQL table?
Arun Singh

Total Post:312

Points:1560

Posted on    May-04-2012 8:34 AM

 PHP PHP 
Ratings:
 1 Answer(s)
  996  View(s)
Rate this:

Arun Singh

Total Post:312

Points:1560
Posted on    May-04-2012 12:00 AM

The syntax for repairing a MySQL table is:

REPAIR TABLE tablename
REPAIR TABLE tablename QUICK
REPAIR TABLE tablename EXTENDED

This command will repair the table specified.
If QUICK is given, MySQL will do a repair of only the index tree.
If EXTENDED is given, it will create index row by row.















Recent Activities

jayprakash sharma Created New Discussion what is short circuit operator in java   18 hours ago

Sumit Kesarwani added new Question What is the Vector class in java?   3 days ago

Anchal Kesharwani added new Blog JSON Syntax   9 days ago

Anchal Kesharwani added new Article How to Send Mail in Node.JS   9 days ago

Top Contributors

Don't want to miss updates? Please click the below button!