- Trending Categories
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