- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How can we analyze the tables of a particular database from MySQL Server command line?
We need to use ‘mysqlcheck’ client program along with –analyze option to analyze the tables of a particular database. Its syntax would be as follows −
Mysqlcheck – u root –analyze db_name
Example
The following command will analyze the tables of database ‘query’ −
C:\mysql\bin>mysqlcheck -u root --analyze query query.cars OK query.copy_cars OK query.countries Table is already up to date query.customers OK query.date_time_test OK query.detail_bday OK query.eeee OK query.emp OK query.emp123 OK query.emp_t OK query.employee12 OK query.employee13 OK query.examination_btech OK query.item_list OK query.item_list1 OK query.new_number OK query.reservation OK query.reservations OK query.reserve OK query.student OK query.student_detail OK query.student_info OK query.student_marks OK query.tender OK query.website OK
Advertisements