Basic PHP Programming Question:

Download Job Interview Questions and Answers PDF

How can we repair a MySQL table?

PHP Interview Question
PHP Interview Question

Answer:

The syntex 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.

Download PHP Interview Questions And Answers PDF

Previous QuestionNext Question
How can we know the number of days between two given dates using PHP?What is the difference between $message and $$message?