+
|
←クリックで開く |
create table test2 (
id int(11) not null auto_increment,
name varchar(50) not null,
sex varchar(5) not null,
japanese int,
math int,
english int,
primary key (id)
);
insert into test (id, name, sex, japanese, math, english) values (1, '山田太郎', '男', 62, 73, 59);
insert into test (id, name, sex, japanese, math, english) values (2, '田中哲夫', '男', 48, 55, 46);
insert into test (id, name, sex, japanese, math, english) values (3, '鈴木康子', '女', 83, 62, 74);
insert into test (id, name, sex, japanese, math, english) values (4, '高橋康弘', '男', 69, 84, 77);
insert into test (id, name, sex, japanese, math, english) values (5, '斉藤若菜', '女', 72, 59, 83);
insert into test (id, name, sex, japanese, math, english) values (6, '山本隆', '男', 43, 51, 60);
insert into test (id, name, sex, japanese, math, english) values (7, '川上哲子', '女', 65, 54, 59);
insert into test (id, name, sex, japanese, math, english) values (8, '小林加奈', '女', 71, 59, 75);
insert into test (id, name, sex, japanese, math, english) values (9, '杉山和彦', '男', 82, 77, 85);
insert into test (id, name, sex, japanese, math, english) values (10, '近藤雅美', '女', 59, 61, 68);
|