+
|
←クリックで開く |
create table tb (
id int(11) not null auto_increment,
bang varchar(50) not null,
uria int,
tuki int,
primary key (id)
);
insert into tb (bang, uria, tuki) values ('A103', 101, 4);
insert into tb (bang, uria, tuki) values ('A102', 54, 5);
insert into tb (bang, uria, tuki) values ('A104', 181, 4);
insert into tb (bang, uria, tuki) values ('A101', 184, 4);
insert into tb (bang, uria, tuki) values ('A103', 17, 5);
insert into tb (bang, uria, tuki) values ('A101', 300, 5);
insert into tb (bang, uria, tuki) values ('A102', 205, 6);
insert into tb (bang, uria, tuki) values ('A104', 93, 5);
insert into tb (bang, uria, tuki) values ('A103', 12, 6);
insert into tb (bang, uria, tuki) values ('A107', 87, 6);
create table tb1 (
id int(11) not null auto_increment,
bang varchar(50) not null,
nama varchar(50) not null,
tosi int,
primary key (id)
);
insert into tb1 (bang, nama, tosi) values ('A101', '佐藤', 40);
insert into tb1 (bang, nama, tosi) values ('A102', '高橋', 28);
insert into tb1 (bang, nama, tosi) values ('A103', '中川', 20);
insert into tb1 (bang, nama, tosi) values ('A104', '渡辺', 23);
insert into tb1 (bang, nama, tosi) values ('A105', '西沢', 35);
create table tb3 (
id int(11) not null auto_increment,
bang varchar(50) not null,
ken varchar(50) not null,
primary key (id)
);
insert into tb3 (bang, ken) values ('A101', '東京都');
insert into tb3 (bang, ken) values ('A102', '埼玉県');
insert into tb3 (bang, ken) values ('A103', '神奈川県');
insert into tb3 (bang, ken) values ('A104', '北海道');
insert into tb3 (bang, ken) values ('A105', '静岡県');
|