기말고사 프로젝트 - 2 데이터삽입

insert into map values(
'lost_temple','128x128','12 2 7 8',152,140,164,182,177,160,'확장기지지먹기쉬움,언덕,힘싸움,전통맵');
insert into map values(
'the hunter','128x128','8방향',253,254,264,283,214,223,'팀플레이기본맵,앞마당확장한개씩');
insert into map values(
'815','128x128','1 5 7 11',23,25,24,28,21,23,'전략형맵,수송기이용');
insert into map values(
'Alchemist','128x128','2,7,11',13,17,14,18,21,23,'개인전맵,여러경로');
insert into map values(
'Arizona','128x128','1 4 8 11',31,29,33,27,31,33,'전술형맵');
insert into map values(
'Ashrigo','128x128','1 5 7 11',17,14,16,18,11,13,'중앙언덕조심');
insert into map values(
'철의 장막','128x128','2 5 7 10',9,6,12,15,11,9,'복합형,섬전+국지전');
insert into map values(
'Bifrost','128x96','6 12',21,26,24,22,26,29,'개인전맵,중앙힘싸움전');
insert into map values(
'Blade Storm','128x128','3 6 9 12',6,5,8,9,7,6,'먼공격거리');

insert into map values(

'파라독스','128x128','2 7',26,25,28,31,29,33,'섬맵 중앙땅차지 중요');
insert into map values(

'우산국','128x128','1 5 7 11',31,29,28,29,35,33,'팀플맵 입구2개');
insert into map values(

'Requiem','128x128','12 3 6 9',18,20,21,22,15,11,'입구가 언덕밑형태라 방어힘듬');
insert into map values(

'Lunathefinal','128x128','1 5 7 11',12,21,17,15,11,11,'중앙힘싸움');
insert into map values(

'발해의 꿈','128x128','1 5 7 11',26,29,18,21,19,23,'반섬맵');
insert into map values(

'Guillotine','128x128','1 5 7 11',28,30,31,32,35,31,'입구가 언덕밑형태라 방어힘듬');
insert into map values(

'Mercury','128x128','2 5 8 11',16,19,18,21,19,13,'자원이 많은 개방형맵 지형이용중요');
insert into map values(

'남자이야기','128x128','1 5 7 11',18,20,11,12,15,21,'본진뒷마당 확장');

 

 

 

 

 

insert into progamer values(
'서지훈','cylion','terran',23,31,29,34,28,30,31,'OLYMPUS배스타리그 우승','GO');
insert into progamer values(
'조용호','mokdong_zerg','zerg',26,23,26,25,24,28,25,'OLYMPUS배스타리그 준우승','KTF');
insert into progamer values(
'박용욱','devil_toss','protoss',24,21,28,25,21,16,14,'MYCUBE배스타리그 우승','SKT T1');
insert into progamer values(
'전태규','jun_tae_gyu','protoss',27,28,21,25,27,21,25,'NHN한게임스타리그 준우승','KOR');
insert into progamer values(
'최연성','haemer','terran',26,35,25,33,29,30,32,'EVER2004스타리그 우승','SKT T1');
insert into progamer values(
'강민','nal_ra','protoss',26,23,25,21,20,18,24,'NHN한게임스타리그 우승,MYCUBE배스타리그준우승','KTF');
insert into progamer values(
'이윤열','nada','terran',23,32,28,30,31,34,29,'IOPS스타리그 우승,2003년 우승','팬택큐리텔');
insert into progamer values(
'이병민','golden_boy','terran',24,21,17,24,25,19,21,'EVER2005스타리그 준우승','팬택큐리텔');

insert into progamer values(
'오영종','sasin_toss','protoss',22,16,14,14,15,17,11,'So1스타리그 우승','PLUS');
insert into progamer values(
'박성준','toosin_zerg','zerg',21,25,15,27,24,20,22,'질레트배 우승,EVER2004스타리그 우승,IOPS스타리그 준우승','POS');
insert into progamer values(
'홍진호','yellow_zerg','zerg',26,24,22,34,35,28,30,'각종대회 준우승 여러번','KTF');
insert into progamer values(
'박정석','hero_toss','protoss',24,29,25,24,26,30,22,'질레트배 준우승,2001년 우승','KTF');
insert into progamer values(
'임요환','slayers_boxer','terran',25,30,24,25,26,32,25,'So1 스타리그 준우승, EVER스타리그준우승,2001년 우승2번','SKT T1');
insert into progamer values(
'강도경','hot_forerver','zerg',26,15,13,15,21,18,17,' ','한빛');
insert into progamer values(
'주진철','jin_chul','zerg',25,19,21,15,18,21,20,' ','KOR');
insert into progamer values(
'김근백','kim_baaak','zerg',22,24,26,25,21,25,21,' ','삼성 KHAN');
insert into progamer values(
'박상익','sannnnnng','zerg',23,20,14,15,20,12,16,' ','SOUL');

insert into progamer values(
'마재윤','mamama','zerg',23,21,29,24,18,10,11,' ','GO');
insert into progamer values(
'염보성','bobosung','terran',19,5,3,5,5,7,5,' ','POS');
insert into progamer values(
'박지호','zillot','protoss',25,25,30,24,26,26,19,' ','POS');
insert into progamer values(
'김정민','the_marrin','terran',22,18,11,15,17,11,15,' ','KTF');
insert into progamer values(
'박대만','daeeeeee','protoss',24,35,25,33,29,30,32,' ','한빛');
insert into progamer values(
'김선기','xmrrhdeo','terran',27,23,25,21,20,18,24,' ','한빛');
insert into progamer values(
'고인규','ingyu','terran',20,33,29,31,32,35,28,' ','SKT T1');
insert into progamer values(
'이주영','go_rush','zerg',23,25,27,14,15,29,31,' ','GO');
insert into progamer values(
'신주영','huhuhu','protoss',28,16,14,14,15,17,11,' ','PLUS');
insert into progamer values(
'최인규','intothe_rain','random',26,25,15,27,24,20,22,' ','삼성 KHAN');
insert into progamer values(
'나도현','cylioonnn','terran',24,24,22,34,35,28,30,' ','KTF');
insert into progamer values(
'차재욱','chacha','terran',22,29,25,24,26,30,22,' ','KOR');
insert into progamer values(
'이재훈','gomdori','protoss',26,30,24,25,26,32,25,' ','GO');
insert into progamer values(
'박정길','parkpark','protoss',22,15,13,15,21,18,17,' ','GO');
insert into progamer values(
'변길섭','fire_terran','terran',25,19,21,15,18,21,20,' ','KTF');
insert into progamer values(
'성학승','sunghak','zerg',27,24,26,25,21,25,21,' ','SKT T1');
insert into progamer values(
'박태민','zergling','zerg',24,20,14,15,20,12,16,' ','SKT T1');
insert into progamer values(
'전상욱','gomgomgom','terran',22,29,25,24,26,30,22,' ','SKT T1');
insert into progamer values(
'송병구','pro_dra','protoss',26,30,24,25,26,32,25,' ','삼성 KHAN');
insert into progamer values(
'변은종','namename','zerg',22,15,13,15,21,18,17,' ','삼성 KHAN');
insert into progamer values(
'심소명','simsomyung','zerg',25,19,21,15,18,21,20,' ','팬택큐리텔');
insert into progamer values(
'안석열','ansukyul','zerg',27,24,26,25,21,25,21,' ','팬택큐리텔');
insert into progamer values(
'박경락','kyungrak_masa','zerg',24,20,14,15,20,12,16,' ','한빛');

insert into progamer values(
'정용학','yonghakjung','protoss',25,10,14,15,10,12,16,' ','GEG');
insert into progamer values(
'김영훈','ch0yh','terran',25,14,20,21,22,18,19,' ','GEG');

 

 

 

 

 

 

 

insert into match values(
 1,'20-7-01','임요환','홍진호','lost_temple',45,'임요환');
insert into match values(
 2,'20-7-01','임요환','홍진호','the hunter',23,'홍진호');
insert into match values(
 3,'20-7-01','임요환','홍진호','Alchemist',14,'임요환');
insert into match values(
 4,'20-7-01','임요환','홍진호','lost_temple',22,'임요환');

insert into match values(
 5,'24-9-01','서지훈','조용호','lost_temple',19,'조용호');
insert into match values(
 6,'15-2-02','박용욱','전태규','Ashrigo',31,'전태규');
insert into match values(
 7,'19-3-02','최연성','강민','815',25,'강민');

insert into match values(
 8,'19-3-02','이윤열','박성준','Bifrost',39,'박성준');
insert into match values(
 9,'20-3-02','강도경','박상익','Blade Storm',14,'강도경');
insert into match values(
 10,'14-4-02','김근백','박정석','815',52,'박정석');

insert into match values(
 11,'15-4-02','서지훈','박상익','Arizona',42,'박상익');
insert into match values(
 12,'16-4-02','조용호','김근백','철의 장막',12,'조용호');
insert into match values(
 13,'2-5-02','박용욱','주진철','815',15,'주진철');
insert into match values(
 14,'3-5-02','전태규','강도경','Bifrost',24,'강도경');
insert into match values(
 15,'3-5-02','최연성','임요환','Ashrigo',44,'최연성');

insert into match values(
 16,'21-7-02','강민','박정석','Arizona',21,'강민');
insert into match values(
 17,'22-7-02','이윤열','홍진호','lost_temple',9,'홍진호');
insert into match values(
 18,'22-7-02','박성준','박상익','Blade Storm',15,'박성준');
insert into match values(
 19,'29-7-02','조용호','임요환','Bifrost',34,'임요환');
insert into match values(
 20,'3-5-02','박용욱','임요환','815',47,'박용욱');

insert into match values(
 21,'20-10-02','마재윤','염보성','lost_temple',45,'마재윤');
insert into match values(
 22,'20-10-02','박지호','김정민','the hunter',23,'김정민');
insert into match values(
 23,'27-10-02','박대만','김선기','Alchemist',14,'김선기');
insert into match values(
 24,'27-10-02','고인규','이주영','lost_temple',22,'이주영');
insert into match values(
 25,'24-1-03','최인규','신주영','lost_temple',19,'최인규');
insert into match values(
 26,'2-2-03','나도현','차재욱','Ashrigo',31,'나도현');
insert into match values(
 27,'19-3-03','이재훈','박정길','815',25,'이재훈');
insert into match values(
 28,'19-5-03','변길섭','성학승','Bifrost',39,'성학승');
insert into match values(
 29,'20-5-03','박태민','전상욱','Blade Storm',14,'박태민');
insert into match values(
 30,'20-5-03','송병구','변은종','815',52,'송병구');
insert into match values(
 31,'15-8-03','심소명','안석열','Arizona',42,'안석열');
insert into match values(
 32,'15-8-03','박경락','정용학','철의 장막',12,'박경락');
insert into match values(
 33,'19-10-03','박상익','김영훈','815',15,'박상익');
insert into match values(
 34,'3-11-03','박지호','안석열','Bifrost',24,'안석열');
insert into match values(
 35,'3-11-03','김정민','송병구','Ashrigo',44,'송병구');
insert into match values(
 36,'2-2-04','이주영','박태민','Arizona',21,'박태민');
insert into match values(
 37,'2-2-04','최인규','박정길','lost_temple',9,'박정길');
insert into match values(
 38,'10-5-04','김선기','박태민','Blade Storm',15,'김선기');
insert into match values(
 39,'10-5-04','최인규','신주영','Bifrost',34,'신주영');
insert into match values(
 40,'21-7-04','강도경','나도현','815',47,'나도현');
insert into match values(
 41,'15-8-04','고인규','홍진호','Arizona',42,'홍진호');
insert into match values(
 42,'15-8-04','마재윤','변은종','철의 장막',12,'변은종');
insert into match values(
 43,'19-10-04','박용욱','차재욱','815',15,'차재욱');
insert into match values(
 44,'19-10-04','주진철','박대만','Bifrost',24,'박대만');
insert into match values(
 45,'18-11-04','고인규','임요환','Ashrigo',44,'임요환');
insert into match values(
 46,'18-11-04','이재훈','박정석','Arizona',21,'박정석');
insert into match values(
 47,'2-2-05','김정민','홍진호','lost_temple',9,'홍진호');
insert into match values(
 48,'3-4-05','안석열','이재훈','Blade Storm',15,'이재훈');
insert into match values(
 49,'19-6-05','박상익','박대만','Bifrost',34,'박대만');
insert into match values(
 50,'21-10-05','주진철','박태민','815',47,'주진철');

기타등등

 

 

 

insert into league values(
'sky프로리그 2005 1round','부산','sky','SKT T1',30000000,'KTF',10000000,'팀전');
insert into league values(
'sky프로리그 2004 3round','대구','sky','한빛',20000000,'큐리어스',5000000,'팀전');
insert into league values(
'sky프로리그 2004 2round','광주','sky','큐리어스',20000000,'SOUL',5000000,'팀전');
insert into league values(
'sky프로리그 2004 1round','서울','sky','한빛',20000000,'SKT T1',5000000,'팀전');
insert into league values(
'네오위즈피망컵프로리그','인천','pmang','GO',15000000,'루나',5000000,'팀전');

insert into league values(
'So1스타리그','인천','So1','오영종',30000000,'임요환',15000000,'개인전');
insert into league values(
'EVER스타리그','목포','EVER','박성준',28000000,'이병민',13000000,'개인전');
insert into league values(
'IOPS스타리그','서울','IOPS','이윤열',25000000,'박성준',10000000,'개인전');
insert into league values(
'EVER스타리그','대전','EVER','최연성',23000000,'임요환',8000000,'개인전');
insert into league values(
'질레트배스타리그','수원','질레트','박성준',22000000,'박정석',7000000,'개인전');
insert into league values(
'NHN한게임스타리그','인천','NHN한게임','강민',20000000,'전태규',5000000,'개인전');
insert into league values(
'MYCUBE배스타리그','서울','MYCUBE','박용욱',18000000,'강민',5000000,'개인전');
insert into league values(
'OLYMPUS스타리그','부산','OLYMPUS','서지훈',15000000,'홍진호',5000000,'개인전');
insert into league values(
'Panasonic스타리그','광주','Panasonic','이윤열',15000000,'조용호',5000000,'개인전');

insert into league values(
'EVER스타리그2005','무주','EVER','박성준P',33000000,'이병민',10000000,'개인전');

 

 

 

insert into team values
('KOR','이명근','주진철','차재욱 한동욱 박정길 전태규 신정민 국기봉','01-01-01',3,7,' ');
insert into team values
('KTF','정수영','홍진호','김정민 이병민 변길섭 강민 박정석 조용호 김민구','01-01-01',7,3,'스카이프로리그2005 1round 준우승');
insert into team values
('SKT T1','주훈','임요환','전상욱 최연성 김성제 박용욱 박태민 성학승','01-01-01',7,4,'sky프로리그20051round 우승, sky프로리그20041round 준우승');
insert into team values
('삼성 KHAN','김가을','김근백','임채성 최수범 송병구 변은종 최인규','01-01-01',5,5,' ');
insert into team values
('SOUL','김은동','박상익','진영수 한승엽 박종수 김남기 곽동훈','01-01-01',5,6,'sky프로리그2004 2round 준우승');
insert into team values
('POS','하태기','박성준','도진광 임채성 문준희 박지호','01-01-01',6,5,' ');
insert into team values
('PLUS','조정웅','오영종','이학주 김성곤 김정환 조홍규','01-01-01',3,8,' ');
insert into team values
('팬택큐리텔','송호창','이윤열','나도현 이병민 안기효 손영훈 심소명 안석열 이재항','01-01-01',7,3,'네오위즈피망컵프로리그준우승, sky프로리그20042round 우승 3round 준우승');
insert into team values
('한빛','이재균','강도경','김선기 유인봉 박대만 김준영 박경락 조형근','01-01-01',2,8,'sky프로리그2004 1,3 round 우승 ');