344
344
insert into t3 select name, name from t1;
346
346
Table Unique Key_name Seq_in_index Column_name
350
350
Table Unique Key_name Seq_in_index Column_name
353
353
explain select * from t1 ignore key(btree_idx), t3 where t1.name='matt' and t3.a = concat('',t1.name) and t3.b=t1.name;
354
354
id select_type table type possible_keys key key_len ref rows Extra
355
355
1 SIMPLE t1 ref heap_idx heap_idx 82 const 9 Using where