225
225
select * from t2 where a NOT IN (0, 2,4,6,8,10,12,14,16,18);
226
226
id select_type table type possible_keys key key_len ref rows Extra
228
228
select * from t2 where a NOT IN (0, 2,4,6,8,10,12,14,16,18);
5795
240
explain select * from t2 force index(a) where a NOT IN (2,2,2,2,2,2);
5796
241
id select_type table type possible_keys key key_len ref rows Extra
5798
243
explain select * from t2 force index(a) where a <> 2;
5799
244
id select_type table type possible_keys key key_len ref rows Extra
5802
247
create table t2 (a datetime, filler char(200), key(a));
5803
248
insert into t2 select '2006-04-25 10:00:00' + interval C.a minute,