220
220
insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
222
222
insert into t2 select C.a*2, 'no' from t1 A, t1 B, t1 C;
223
223
insert into t2 select C.a*2+1, 'yes' from t1 C;
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);