是指做了delete之后吗?可以使用optimize table tablename;如果是innodb的表话,要注意You can make OPTIMIZE TABLE work on other storage engines by starting mysqld with the --skip-new or --safe-mode option. In this case, OPTIMIZE TABLE is just mapped to ALTER ...
显示全部是指做了delete之后吗?可以使用optimize table tablename;
如果是innodb的表话,要注意
You can make OPTIMIZE TABLE work on other storage engines by starting mysqld with the --skip-new or --safe-mode option. In this case, OPTIMIZE TABLE is just mapped to ALTER TABLE.
当然你也可以重建
收起