153
153
create table t1 ( myfield INT NOT NULL, UNIQUE INDEX (myfield), unique (myfield), index(myfield));
158
158
insert into t1 values (1), (2);
159
159
insert into t2 values (1);
160
160
select t1.id as id_A, t2.id as id_B from t1 left join t2 using ( id );
161
161
select t1.id as id_A, t2.id as id_B from t1 left join t2 on (t1.id = t2.id);
163
163
insert into t3 select t1.id as id_A, t2.id as id_B from t1 left join t2 using ( id );