Question
Write a command with which MySQL table can be repaired?
Answers
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.   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q What is the UI response time limit in android. (I.E with in how many seconds main thread has to respond for user actions?)
  • Q Life cycle of an applet includes which steps
  • Q What are rollup groups?
  • Q The first Butlins holiday camp opened in which English seaside resort?
  • Q How to Save UI States in Case of Configuration Changes in Android?
  • Q A muster is a group of which birds
  • Q What items are important in every Android project?
  • Q What science ficton author wrote about The Cities in Flight series
  • Q what is the abbreviation of MRVNL
  • Q Why is a Block in HDFS So Large?
  • Q Explain high-order and low-order bytes.