版本:
表字段:
索引:
explain select t.* from test t where t.name3 <> 'a';
explain select t.* from test t where t.name3 != 'a';
亲测,不等于号索引不失效
版本:
表字段:
索引:
explain select t.* from test t where t.name3 <> 'a';
explain select t.* from test t where t.name3 != 'a';
亲测,不等于号索引不失效