在phpmyadmin中
use information_schema;
SELECT concat('repair table ',table_name,' ;')
FROM `TABLES` where table_schema='databasename';
获取结果后在复制出结果集,执行结果集就行了;
在phpmyadmin中
use information_schema;
SELECT concat('repair table ',table_name,' ;')
FROM `TABLES` where table_schema='databasename';
获取结果后在复制出结果集,执行结果集就行了;