我们如何通过 MySQL 服务器命令行来分析特定数据库的表?
我们需要使用 **'mysqlcheck'** 客户端程序配合 –analyze 选项来分析特定数据库的表。其语法如下 −
Mysqlcheck – u root –analyze db_name
实例
以下命令将分析数据库“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
广告