📄 key_primary.result
字号:
drop table if exists t1;create table t1 (t1 char(3) primary key);insert into t1 values("ABC");insert into t1 values("ABA");insert into t1 values("AB%");select * from t1 where t1="ABC";t1ABCselect * from t1 where t1="ABCD";t1select * from t1 where t1 like "a_\%";t1AB%describe select * from t1 where t1="ABC";id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE t1 const PRIMARY PRIMARY 3 const 1 Using indexdescribe select * from t1 where t1="ABCD";id select_type table type possible_keys key key_len ref rows Extra1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tablesdrop table t1;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -