Lines Matching refs:keyc
2 (keyc int, c1 char(100), c2 char(100),
3 primary key(keyc), index sec_index(c1)
6 (keyc int, c1 char(100), c2 char(100),
7 primary key(keyc), index sec_index(c1)
42 keyc c1 c2
83 delete from t1 where keyc <= 60;
92 keyc c1 c2
108 select * from t1 where keyc > 30 limit 10;
109 keyc c1 c2
124 select * from t1 where keyc > 30 limit 10;
125 keyc c1 c2
136 update t1 set keyc = keyc + 2000;
138 keyc c1 c2
151 update t1 set keyc = keyc + 2000;
153 keyc c1 c2
166 keyc c1 c2
179 keyc c1 c2
190 insert into t2 select * from t1 where keyc < 2101;
199 (keyc int, c1 char(100), c2 char(100),
200 primary key(keyc), index sec_index(c1)
204 (keyc int, c1 char(100), c2 char(100),
205 primary key(keyc), index sec_index(c1)
209 (keyc int, c1 char(100), c2 char(100),
210 primary key(keyc), index sec_index(c1)
246 keyc c1 c2
287 delete from t1 where keyc <= 60;
296 keyc c1 c2
312 select * from t1 where keyc > 30 limit 10;
313 keyc c1 c2
328 select * from t1 where keyc > 30 limit 10;
329 keyc c1 c2
340 update t1 set keyc = keyc + 2000;
342 keyc c1 c2
355 update t1 set keyc = keyc + 2000;
357 keyc c1 c2
370 keyc c1 c2
383 keyc c1 c2
394 insert into t2 select * from t1 where keyc < 2101;
403 (keyc int, c1 char(100), c2 char(100),
404 primary key(keyc), index sec_index(c1)
407 (keyc int, c1 char(100), c2 char(100),
408 primary key(keyc), index sec_index(c1)
443 keyc c1 c2
484 delete from t1 where keyc <= 60;
493 keyc c1 c2
509 select * from t1 where keyc > 30 limit 10;
510 keyc c1 c2
525 select * from t1 where keyc > 30 limit 10;
526 keyc c1 c2
537 update t1 set keyc = keyc + 2000;
539 keyc c1 c2
552 update t1 set keyc = keyc + 2000;
554 keyc c1 c2
567 keyc c1 c2
580 keyc c1 c2
591 insert into t2 select * from t1 where keyc < 2101;