How can we repair a MySQL table?

Last updated 6 years, 2 months ago | 1940 views 75 5

MySQL | Repair Table

REPAIR command is used for repair a MySQL table

REPAIR TABLE users

We can also specify Quick and Extended after the table name

REPAIR TABLE users QUICK

If we specify Quick then MySQL will do a repair of only the index tree.

REPAIR TABLE users EXTENDED

But if we specify the extended then it creates index row by row.

What do you mean by foreign key?

Explain how to delete a file in Python?

Comments in PHP

A non-numeric value encountered in PHP

Remove id attribute from an element using jquery

Insert and Get data from an Elasticsearch index in python