INSERT INTO author (id, name, kana, sex) VALUES (1, '夏目漱石', 'なつめそうせき', '男');
INSERT INTO author (id, name, kana, sex) VALUES (2, '宮沢賢治', 'みやざわけんじ', '男');
INSERT INTO author (id, name, kana, sex) VALUES (3, '芥川龍之介', 'あくたがわりゅうのすけ', '男');
INSERT INTO author (id, name, kana, sex) VALUES (4, '与謝野晶子', 'よさのあきこ', '女');
INSERT INTO author (id, name, kana, sex) VALUES (5, '木村聡', 'きむらさとし', '男');

INSERT INTO book (id, author_id, title) VALUES (1, 1, '吾輩は猫である');
INSERT INTO book (id, author_id, title) VALUES (2, 2, '銀河鉄道の夜');
INSERT INTO book (id, author_id, title) VALUES (3, 3, '羅生門');
INSERT INTO book (id, author_id, title) VALUES (4, 4, 'みだれ髪');
INSERT INTO book (id, author_id, title) VALUES (5, 1, '坊ちゃん');
INSERT INTO book (id, author_id, title) VALUES (6, 3, '蜘蛛の糸');
INSERT INTO book (id, author_id, title) VALUES (7, 1, 'こころ');
INSERT INTO book (id, author_id, title) VALUES (8, 5, 'Eclipseで学ぶはじめてのJava');
INSERT INTO book (id, author_id, title) VALUES (9, 5, 'Javaフレームワーク開発入門');
