repair table

mysql> show create table lixl;
+-------+----------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------------------------------------+
| lixl | CREATE TABLE `lixl` (
`name` char(20) DEFAULT NULL,
`id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> repair table lixl;
+----------+--------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------+--------+----------+---------------------------------------------------------+
| dqy.lixl | repair | note | The storage engine for the table doesn't support repair |
+----------+--------+----------+---------------------------------------------------------+
1 row in set (0.00 sec)

************************************************************************************

mysql> create table db (name char(20),id int not null) engine=myisam;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into db (name) values("hx"),("jh");
Query OK, 2 rows affected, 1 warning (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 1

mysql> select * from db;
+------+----+
| name | id |
+------+----+
| hx | 0 |
| jh | 0 |
+------+----+
2 rows in set (0.00 sec)

mysql> repair table db;
+--------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------+--------+----------+----------+
| dqy.db | repair | status | OK |
+--------+--------+----------+----------+
1 row in set (0.00 sec)

转载于:https://www.cnblogs.com/seasonsstory/p/3476223.html