Lines Matching refs:key1
28 key1 int(11),
31 KEY key1 (key1),
44 explain select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
45 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
51 key1 int(11),
54 KEY key1 (key1),
62 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
68 key1 int(11),
71 KEY key1 (key1),
78 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
86 key1 int(11),
89 KEY key1 (key1),
96 insert ignore into t1 select pk1, char(0xEC), pk3, key1, key2 from t1;
97 insert ignore into t1 select pk1, 'x', pk3, key1, key2 from t1 where pk2='u';
98 insert ignore into t1 select 2, pk2, pk3, key1, key2 from t1;
100 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
105 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;
113 key1 int(11),
116 KEY key1 (key1),
124 select * from t1 force index(key1, key2) where key1 < 3 or key2 < 3;