📄 repair.result
字号:
drop table if exists t1;create table t1 SELECT 1,"table 1";repair table t1 use_frm;Table Op Msg_type Msg_texttest.t1 repair warning Number of rows changed from 0 to 1test.t1 repair status OKalter table t1 ENGINE=HEAP;repair table t1 use_frm;Table Op Msg_type Msg_texttest.t1 repair note The storage engine for the table doesn't support repairdrop table t1;create table t1(id int PRIMARY KEY, st varchar(10), KEY st_key(st));insert into t1 values(1, "One");alter table t1 disable keys;show keys from t1;Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Commentt1 0 PRIMARY 1 id A 1 NULL NULL BTREE t1 1 st_key 1 st A NULL NULL NULL YES BTREE disabledrepair table t1 extended;Table Op Msg_type Msg_texttest.t1 repair status OKshow keys from t1;Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Commentt1 0 PRIMARY 1 id A 1 NULL NULL BTREE t1 1 st_key 1 st A NULL NULL NULL YES BTREE disableddrop table t1;repair table t1 use_frm;Table Op Msg_type Msg_texttest.t1 repair error Table 'test.t1' doesn't existWarnings:Error 1146 Table 'test.t1' doesn't existcreate table t1 engine=myisam SELECT 1,"table 1";flush tables;repair table t1;Table Op Msg_type Msg_texttest.t1 repair error Incorrect file format 't1'Warnings:Error 130 Incorrect file format 't1'repair table t1 use_frm;Table Op Msg_type Msg_texttest.t1 repair warning Number of rows changed from 0 to 1test.t1 repair status OKdrop table t1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -