bitscn.com脚本如下：
drop table table1;
create table `andrew`.`table1`
(
`name` varchar(32) not null,
`city` varchar(32) not null
)
engine = myisam;
insert into table1(name, city) values ('person a', 'bj');
insert into table1(name, city) values ('person b', 'bj');
insert into table1(name, city) values ('person c', 'sh');
insert into table1(name, city) values ('person d', 'sz');
commit;
drop table table2;
create table `andrew`.`table2`
(
`name` varchar(32) not null,
`city` varchar(32) not null
)
engine = myisam;
insert into table2(name, city) values ('person w', 'bj');
insert into table2(name, city) values ('person x', 'sh');
insert into table2(name, city) values ('person y', 'sh');
insert into table2(name, city) values ('person z', 'nj');
commit;
1. 外连接