soccer .sql postgresql version ddl, dml

 

다 입력하면 다음과 같이 출력됩니다.

 

실행 순서 1

CREATE TABLE stadium (
    stadium_id    VARCHAR(10) PRIMARY KEY,
    stadium_name  VARCHAR(40),
    hometeam_id   VARCHAR(10),  -- team.team_id와 연관
    seat_count    INTEGER,
    address       VARCHAR(60),
    ddd           VARCHAR(10),
    tel           VARCHAR(10)
);
CREATE TABLE team (
    team_id       VARCHAR(50) PRIMARY KEY,
    region_name   VARCHAR(50),
    team_name     VARCHAR(100),
    e_team_name   VARCHAR(50),
    orig_yyyy     VARCHAR(10),
    zip_code1     VARCHAR(10),
    zip_code2     VARCHAR(10),
    address       VARCHAR(100),
    ddd           VARCHAR(50),
    tel           VARCHAR(20),
    fax           VARCHAR(20),
    homepage      VARCHAR(100),
    owner         VARCHAR(50),
    stadium_id    VARCHAR(20),
    FOREIGN KEY (stadium_id) REFERENCES stadium(stadium_id)
);
CREATE TABLE schedule (
    sche_date     VARCHAR(10),  -- PK 후보로 사용할 수 있음
    stadium_id    VARCHAR(10),
    gubun         VARCHAR(10),
    hometeam_id   VARCHAR(10),
    awayteam_id   VARCHAR(10),
    home_score    INTEGER,
    away_score    INTEGER,
    FOREIGN KEY (stadium_id) REFERENCES stadium(stadium_id),
    FOREIGN KEY (hometeam_id) REFERENCES team(team_id),
    FOREIGN KEY (awayteam_id) REFERENCES team(team_id)
);
CREATE TABLE player (
    player_id        VARCHAR(10) PRIMARY KEY,
    player_name      VARCHAR(20),
    e_player_name    VARCHAR(50),
    nickname         VARCHAR(30),
    join_yyyy        VARCHAR(4),
    position         VARCHAR(10),
    back_no          INTEGER,
    nation           VARCHAR(20),
    birth_date       DATE,
    solar            VARCHAR(10),
    height           INTEGER,
    weight           INTEGER,
    team_id          VARCHAR(10),
    FOREIGN KEY (team_id) REFERENCES team(team_id)
);

 

 

 

 

실행 순서 2

 

INSERT INTO STADIUM (
    stadium_id, stadium_name, hometeam_id, seat_count, address, ddd, tel
) VALUES
    ('D03', '전주월드컵경기장', 'K05', 28000, '전북 전주시 덕진구 반월동 763-1', '063', '273-1763'),
    ('B02', '성남종합운동장', 'K08', 27000, '경기도 성남시 분당구 야탑동 486', '031', '753-3956'),
    ('C06', '포항스틸야드', 'K03', 25000, '경북 포항시 남구 괴동 1', '054', '282-2002'),
    ('D01', '광양전용경기장', 'K07', 20009, '전남 광양시 금호동 700', '061', '792-5600'),
    ('B05', '서울월드컵경기장', 'K09', 66806, '서울특별시 마포구 난지도길 66', '02', '2128-2973'),
    ('B01', '인천월드컵경기장', 'K04', 35000, '인천광역시 남구 문학동 482', '031', '666-0496'),
    ('C05', '창원종합운동장', 'K11', 27085, '경남 창원시 두대동 145', '055', '6644-8468'),
    ('C04', '울산문수경기장', 'K01', 46102, '울산광역시 남구 옥산 산5', '052', '220-2468'),
    ('D02', '대전월드컵경기장', 'K10', 41000, '대전광역시 유성구 노은동 270', '042', '252-2002'),
    ('B04', '수원월드컵경기장', 'K02', 50000, '수원시 팔달구 우만1동 228번지', '031', '259-2150'),
    ('A02', '광주월드컵경기장', 'K12', 40245, '광주광역시 서구 풍암동 423-2', '062', '2468-8642'),
    ('C02', '부산아시아드경기장', 'K06', 30000, '부산광역시 서구 서대신동 3가 210번지', '051', '247-5771'),
    ('A03', '강릉종합경기장', 'K13', 33000, '강원 강릉시 교동 산58', '033', '459-3631'),
    ('A04', '제주월드컵경기장', 'K14', 42256, '제주 서귀포시 법환동', '064', '3631-2460'),
    ('A05', '대구월드컵경기장', 'K15', 66422, '대구광역시 수성구 대흥동 504', '053', '602-2011'),
    ('F01', '대구시민경기장', NULL, 30000, '대구광역시', '054', NULL),
    ('F02', '부산시민경기장', NULL, 30000, '부산광역시', '051', NULL),
    ('F03', '일산경기장', NULL, 20000, '경기도 일산시', '031', NULL),
    ('F04', '마산경기장', NULL, 20000, '경남 마산시', '055', NULL),
    ('F05', '안양경기장', NULL, 20000, '경기도 안양시', '031', NULL);
COMMIT;

 

 

실행 순서 3

INSERT INTO team VALUES
('K05','전북','현대모터스','CHUNBUK  HYUNDAI MOTORS  FC','1995','D03','560','190',
'전북 전주시 덕진구 반월동 763-1  전주월드컵경기장  내','063','273-1763','273-1762','http://www.hyundai-motorsfc.com', NULL),
('K08','성남','일화천마','SEONGNAM  ILHWA CHUNMA FC','1988','B02','462','130',
'경기도 성남시 분당구 야탑동  486번지 성남 제2종합운동장  내','031','753-3956','753-4443','http://www.esifc.com', NULL),
('K03','포항','스틸러스','FC POHANG  STEELERS','1973','C06','790','050',
'경북 포항시 죽도동 614-8 동양빌딩  7층','054','282-2002','282-5955','http://www.steelers.co.kr', NULL),
('K07','전남','드래곤즈','CHUNNAM  DRAGONS FC','1994','D01','544','010',
'전남 광양시 중동 1318-5 신한은행빌딩  2층','061','792-5600','792-5605','http://www.dragons.co.kr', NULL),
('K09','서울','FC서울','FOOTBALL CLUB  SEOUL','1983','B05','138','221',
'서울 마포구 성산동 515 월드컵 경기장  내','02','2005-5746','2005-5802','http://www.fcseoul.com', NULL),
('K04','인천','유나이티드','INCHEON  UNITED FC','2004','B01','110','728',
'인천광역시 남구 문학동 482  인천월드컵경기장  내','032','2121-5271','2121-5276','http://www.incheonutd.com', NULL),
('K11','경남','경남FC','GYEONGNAM  FC','2006','C05','111','222',
'경남 창원시 두대동 145  창원종합운동장','055','6644-8468','6644-8488','http://www.gsndfc.co.kr', NULL),
('K01','울산','울산현대','ULSAN HYUNDAI  FC','1986','C04','682','060',
'울산광역시 동구 서부동 산137-1  현대스포츠클럽하우스','052','230-6141','230-6145','http://www.uhfc.tv', NULL),
('K10','대전','시티즌','DAEJEON CITIZEN  FC','1996','D02','301','030',
'대전광역시 유성구 노은동 270  대전월드컵경기장 서관  3층','042','252-2002','221-0669','http://www.dcfc.co.kr', NULL),
('K02','수원','삼성블루윙즈','SUWON  SAMSUNG BLUEWINGS  FC','1995','B04','440','220',
'수원시 팔달구 우만1동 228  수원월드컵경기장  4층','031','247-2002','257-0766','http://www.bluewings.kr', NULL),
('K12','광주','광주상무','GWANGJU  SANGMU FC','1984','A02','450','419',
'광주광역시 서구 풍암동 423-2  광주월드컵경기장  내','062','777-5180','777-5181','http://www.gwangjusmfc.co.kr', NULL),
('K06','부산','아이파크','BUSAN IPARK  FC','1983','C02','570','050',
'부산광역시 강서구 대저1동 2155번지  강서체육공원  내','051','555-7101','555-7103','http://www.busanipark.co.kr', NULL),
('K13','강원','강원FC','GANGWON  FC','2008','A03','333','444',
'강원 춘천시 중앙로 7 강원도 개발공사  빌딩  내','033','459-3631','459-3630','http://www.gangwon-fc.com', NULL),
('K14','제주','제주유나이티드FC','JEJU  UNITED FC','1982','A04','555','666',
'제주 서귀포시 강정동  3355-5','064','3631-2460','3631-2468','http://www.jeju-utd.com', NULL),
('K15','대구','대구FC','DAEGU  FC','2002','A05','777','888',
'대구광역시 수성구 대흥동 504  대구스타디움  내','053','5566-3967','5566-3970','http://www.daegufc.co.kr', NULL);

 

 

 

실행 순서 4 - 1

INSERT INTO player (player_id, player_name, e_player_name, nickname, join_yyyy, position, back_no, nation, birth_date, solar, height, weight, team_id) VALUES
('2009175', '우르모브', NULL, NULL, '2009', 'DF', 4, '유고', '1987-08-30'::date, 1, 180, 70, 'K06'),
('2007188', '윤희준', NULL, NULL, '2005', 'DF', 15, NULL, '1982-11-01'::date, 1, 180, 74, 'K06'),
('2012073', '김규호', NULL, NULL, '2011', 'DF', 23, NULL, '1989-07-13'::date, 1, 177, 72, 'K06'),
('2007178', '김민성', NULL, NULL, NULL, 'DF', 20, NULL, '1983-06-23'::date, 1, 182, 73, 'K06'),
('2007191', '김장관', NULL, '배추도사,작은삼손', '2007', 'DF', 18, NULL, '1984-06-05'::date, 2, 170, 61, 'K06'),
('2008384', '김정효', NULL, '깜둥이,통키통', '2008', 'DF', 19, NULL, '1985-07-23'::date, 2, 174, 68, 'K06'),
('2008395', '장대일', NULL, '달구', '2010', 'DF', 7, NULL, '1985-03-09'::date, 2, 184, 79, 'K06'),
('2011050', '박상수', NULL, '꼬마홍길동', '2011', 'DF', 36, NULL, '1988-06-14'::date, 1, 173, 65, 'K06'),
('2007189', '정재영', NULL, '제리', '2006', 'MF', 6, NULL, '1983-09-02'::date, 2, 187, 75, 'K06'),
('2011049', '정태민', NULL, '킹카', '2011', 'MF', 38, NULL, '1992-05-25'::date, 1, 180, 71, 'K06'),
('2010107', '정현우', NULL, NULL, '2010', 'MF', 37, NULL, '1991-06-04'::date, 1, 178, 70, 'K06'),
('2011043', '송종국', NULL, '썰렁왕자', '2011', 'MF', 24, NULL, '1989-02-20'::date, 1, 177, 73, 'K06'),
('2011044', '오정석', NULL, '서경석', '2011', 'MF', 13, NULL, '1988-09-08'::date, 1, 178, 74, 'K06'),
('2012137', '이고르', '이골 실바 데 페리이따스', '이골', '2012', 'MF', 21, '브라질', '1989-10-25'::date, 1, 181, 76, 'K06'),
('2007200', '김용하', NULL, '용식이', '2007', 'MF', 26, NULL, '1983-12-15'::date, 2, 173, 66, 'K06'),
('2012072', '전상배', NULL, NULL, '2012', 'MF', 14, NULL, '1989-03-22'::date, 1, 176, 67, 'K06'),
('2009038', '전우근', NULL, '에너자이져', '2009', 'MF', 11, NULL, '1987-02-25'::date, 2, 175, 68, 'K06'),
('2008365', '이태성', NULL, NULL, '2011', 'MF', 30, NULL, '1987-06-16'::date, 1, 177, 64, 'K06'),
('2011047', '황철민', NULL, '사다리맨', '2011', 'MF', 35, NULL, '1988-11-20'::date, 1, 175, 68, 'K06'),
('2008235', '정관규', NULL, NULL, NULL, 'FW', 39, NULL, '1986-10-10'::date, 1, 178, 71, 'K06'),
('2011048', '정기종', NULL, NULL, '2011', 'FW', 25, NULL, '1985-05-22'::date, 1, 182, 78, 'K06'),
('2012074', '정창오', NULL, '임땡', '2012', 'FW', 27, NULL, '1988-01-10'::date, 1, 186, 82, 'K06'),
('2012127', '디디', 'Sebastiao Pereira do Nascimento', NULL, '2012', 'FW', 8, '브라질', '1986-02-24'::date, 1, 179, 78, 'K06'),
('2007182', '마니치', NULL, '바람의 아들', '2006', 'FW', 9, NULL, '1982-01-16'::date, 2, 184, 80, 'K06'),
('2007195', '우성용', NULL, '따따', '2006', 'FW', 22, NULL, '1983-08-18'::date, 2, 191, 76, 'K06'),
('2010103', '장기봉', NULL, '짝팔', '2010', 'FW', 12, NULL, '1987-07-08'::date, 1, 180, 71, 'K06'),
('2012075', '이광수', NULL, NULL, '2012', 'FW', 29, NULL, '1989-09-25'::date, 1, 177, 73, 'K06'),
('2010087', '하리', NULL, NULL, '2010', 'FW', 10, '콜롬비아', '1984-05-14'::date, 1, 168, 65, 'K06'),
('2000017', '박상남', NULL, NULL, '2008', 'FW', 32, NULL, '1985-09-07'::date, 2, 188, 80, 'K06'),
('2000018', '빅토르', NULL, '빅토르', '2011', 'FW', 28, '나이지리아', '1985-01-05'::date, 1, 183, 79, 'K06'),
('2000021', '이윤겸', 'LEE, YOONGYUM', NULL, '2002', 'DF', NULL, NULL, NULL::date, NULL, 178, 80, 'K04'),
('2000022', '하재훈', 'HA, JAEHON', NULL, '2002', 'DF', NULL, NULL, NULL::date, NULL, 174, 67, 'K04'),
('2000023', '김충호', 'KIM, CHUNGHO', NULL, '2009', 'DF', NULL, NULL, NULL::date, NULL, 185, 83, 'K04'),
('2000024', '임기한', 'LIM, GIHAN', NULL, '2004', 'DF', NULL, NULL, NULL::date, NULL, 177, 85, 'K04'),
('2000025', '김경태', 'KIM, KYOUNGTAE', NULL, NULL, 'DF', NULL, NULL, NULL::date, NULL, NULL, NULL, 'K04');

 

 

실행 순서 4 - 2

INSERT INTO player (player_id, player_name, e_player_name, nickname, join_yyyy, position, back_no, nation, birth_date, solar, height, weight, team_id) VALUES
('2012054', '남현우', NULL, NULL, NULL, 'GK', 31, NULL, '1989-04-20'::date, 2, 180, 72, 'K04'),
('2008499', '김충호', NULL, NULL, NULL, 'GK', 60, NULL, '1978-07-04'::date, 2, 185, 83, 'K04'),
('2011021', '이현', NULL, NULL, NULL, 'GK', 1, NULL, '1988-11-07'::date, 2, 192, 85, 'K04'),
('2012052', '한동진', NULL, NULL, NULL, 'GK', 21, NULL, '1989-08-25'::date, 2, 183, 78, 'K04'),
('2012126', '다오', NULL, NULL, NULL, 'DF', 61, NULL, '1992-09-25'::date, 2, 190, 80, 'K04'),
('2008182', '최철', NULL, NULL, NULL, 'DF', 15, NULL, '1983-08-20'::date, 2, 176, 77, 'K04'),
('2010112', '송창남', NULL, NULL, NULL, 'DF', 23, NULL, '1987-12-31'::date, 2, 175, 67, 'K04'),
('2008424', '조승호', NULL, NULL, NULL, 'DF', 2, NULL, '1985-05-13'::date, 2, 179, 70, 'K04'),
('2008450', '윤중희', NULL, NULL, NULL, 'DF', 5, NULL, '1985-12-08'::date, 1, 177, 75, 'K04'),
('2011022', '김범직', NULL, NULL, NULL, 'DF', 25, NULL, '1989-02-11'::date, 1, 182, 75, 'K04'),
('2012053', '김상홍', NULL, NULL, NULL, 'DF', 30, NULL, '1989-02-04'::date, 1, 178, 68, 'K04'),
('2000001', '김태호', NULL, NULL, NULL, 'DF', NULL, NULL, '1971-01-29'::date, 1, NULL, NULL, 'K10'),
('2000002', '정상수', 'JEONG,  SAMSOO', NULL, NULL, 'DF', NULL, NULL, '1973-02-08'::date, 1, NULL, NULL, 'K10'),
('2000003', '유동우', 'YOU,  DONGWOO', NULL, NULL, 'DF', 40, NULL, '1978-03-07'::date, 1, 177, 70, 'K10'),
('2000004', '전기현', 'JEON,  GIHYUN', NULL, NULL, 'DF', NULL, NULL, '1975-06-06'::date, 1, NULL, NULL, 'K10'),
('2012047', '강성일', 'KANG,  SUNGIL', NULL, '2012', 'GK', 30, NULL, '1989-06-04'::date, 1, 182, 80, 'K10'),
('2010057', '김승준', 'KIM,  SEUNGJUN', '개구멍', '2010', 'GK', 1, NULL, '1982-09-01'::date, 1, 183, 77, 'K10'),
('2007298', '이은성', 'LEE,  EUNSUNG', '수호천황', '2007', 'GK', 21, NULL, '1981-04-05'::date, 1, 184, 82, 'K10'),
('2007312', '정대수', 'JEONG,  DAESOO', NULL, '2007', 'DF', 15, NULL, '1985-03-20'::date, 1, 184, 74, 'K10'),
('2012051', '정민기', NULL, NULL, NULL, 'DF', 3, NULL, '1988-04-25'::date, 1, 171, 65, 'K10'),
('2010110', '정성근', 'JEONG,  SUNGKEUN', NULL, '2010', 'DF', 33, NULL, '1987-06-20'::date, 1, 180, 73, 'K10'),
('2011098', '정영근', 'JEONG,  YOUNGKWEN', NULL, '2011', 'DF', 5, NULL, '1988-10-12'::date, 1, 180, 70, 'K10'),
('2007301', '정정수', 'JEONG,  JUNGSOO', NULL, '2002', 'DF', 36, NULL, '1985-01-17'::date, 2, 180, 74, 'K10'),
('2007309', '김창엽', 'KIM,  CHANGYUP', NULL, '2007', 'DF', 6, NULL, '1984-11-19'::date, 2, 174, 64, 'K10'),
('2007299', '장철우', 'JANG,  CHULWOO', '폭주기관차', '2010', 'DF', 7, NULL, '1981-04-01'::date, 2, 172, 65, 'K10'),
('2011116', '콜리', 'OMAR PAPA  COLY', '검은낙타(Black  Camel)', '2011', 'DF', 29, '세네갈', '1985-05-20'::date, 1, 182, 75, 'K10'),
('2007313', '홍광철', 'HONG,  KWANGCHUL', NULL, '2007', 'DF', 4, NULL, '1984-10-09'::date, 2, 172, 65, 'K10'),
('2008461', '강정훈', 'KANG,  JUNGHOON', NULL, '2008', 'MF', 38, NULL, '1986-02-20'::date, 1, 175, 65, 'K10'),
('2007306', '공오균', 'KONG,  OHKYUN', 'CROW', '2007', 'MF', 22, NULL, '1984-08-10'::date, 2, 177, 72, 'K10'),
('2012049', '정국진', 'JEONG,  KOOKJIN', NULL, '2012', 'MF', 16, NULL, '1988-02-09'::date, 1, 172, 62, 'K10'),
('2011099', '정동선', 'JEONG,  DONGSUN', NULL, '2011', 'MF', 9, NULL, '1988-03-15'::date, 1, 170, 65, 'K10'),
('2010109', '최경규', 'CHOI,  KUNGGUY', NULL, '2010', 'MF', 10, NULL, '1987-03-10'::date, 1, 177, 72, 'K10'),
('2010111', '최내철', 'CHOI,  RAECHEOL', NULL, '2010', 'MF', 24, NULL, '1987-08-20'::date, 1, 177, 71, 'K10'),
('2012048', '배성재', 'BAE,  SUNGJAE', NULL, '2012', 'MF', 28, NULL, '1989-07-01'::date, 1, 178, 74, 'K10'),
('2012121', '샴', NULL, NULL, NULL, 'MF', 25, NULL, '1989-04-30'::date, 1, 174, 69, 'K10'),
('2012136', '오비나', NULL, NULL, NULL, 'MF', 26, NULL, '1990-06-03'::date, 1, 169, 70, 'K10'),
('2010056', '김관우', 'KIM,  KWANWOO', 'SIRIUS', '2010', 'MF', 8, NULL, '1988-02-25'::date, 1, 175, 69, 'K10'),
('2012050', '김광진', 'KIM,  KWANGJIN', NULL, '2012', 'MF', 13, NULL, '1982-05-27'::date, 1, 175, 75, 'K10'),
('2010113', '김상규', 'KIM,  SANGKYU', NULL, '2010', 'MF', 27, NULL, '1987-09-05'::date, 1, 175, 65, 'K10'),
('2009151', '임영주', 'LIM,  YOUNGJOO', NULL, '2009', 'MF', 23, NULL, '1986-03-08'::date, 2, 176, 68, 'K10'),
('2011101', '박영훈', 'PARK,  YOUNGHOON', NULL, '2011', 'MF', 12, NULL, '1985-05-01'::date, 1, 174, 73, 'K10'),
('2008178', '한정국', 'HAN,  JUNGKOOK', NULL, '2011', 'MF', 19, NULL, '1981-07-19'::date, 1, 179, 71, 'K10'),
('2012046', '정광선', 'JEONG,  KWANGSUN', NULL, '2012', 'FW', 32, NULL, '1993-06-17'::date, 1, 175, 68, 'K10'),
('2007315', '정은중', 'JEONG,  EUNJUNG', '샤프(SHARP)', '2007', 'FW', 18, NULL, '1989-04-08'::date, 2, 184, 72, 'K10'),
('2009152', '정찬중', 'JEONG.  CHANJOONG', NULL, '2009', 'FW', 17, NULL, '1986-06-14'::date, 2, 182, 72, 'K10'),
('2011032', '김석', 'KIM,  SEOK', NULL, '2012', 'FW', 20, NULL, '1989-02-01'::date, 1, 194, 85, 'K10'),
('2011100', '탁준석', 'TAK,  JUNSUK', NULL, '2011', 'FW', 11, NULL, '1988-03-24'::date, 1, 178, 69, 'K10');

 

 

실행 순서 4 - 3

INSERT INTO player (player_id, player_name, e_player_name, nickname, join_yyyy, position, back_no, nation, birth_date, solar, height, weight, team_id) VALUES
('2000011', '정호곤', NULL, NULL, '2010', 'DF', NULL, NULL, '1971-03-26'::date, 1, 172, 77, 'K06'),
('2000012', '최경훈', NULL, NULL, NULL, 'DF', NULL, NULL, '1971-01-19'::date, 1, NULL, NULL, 'K06'),
('2000013', '정동훈', NULL, NULL, '2010', 'DF', NULL, NULL, '1975-06-11'::date, 1, 180, 88, 'K06'),
('2000014', '정남표', NULL, NULL, '2005', 'DF', NULL, NULL, '1974-01-27'::date, 2, 180, 77, 'K06'),
('2000015', '정광재', NULL, NULL, '2005', 'DF', NULL, NULL, '1978-05-30'::date, 2, 180, 75, 'K06'),
('2000016', '권혁준', NULL, NULL, '2006', 'DF', NULL, NULL, '1980-05-22'::date, 1, 173, 82, 'K06'),
('2011052', '정경진', NULL, '임꺽정', '2011', 'GK', 41, NULL, '1988-02-07'::date, 2, 186, 78, 'K06'),
('2012076', '정용대', NULL, NULL, '2012', 'GK', 40, NULL, '1989-10-11'::date, 1, 189, 83, 'K06'),
('2010108', '정지혁', NULL, NULL, '2010', 'GK', 31, NULL, '1991-11-22'::date, 1, 187, 77, 'K06'),
('2010059', '박유석', NULL, '터프가이', '2010', 'GK', 1, NULL, '1987-06-10'::date, 2, 186, 78, 'K06'),
('2011053', '정진우', NULL, '터프가이', '2011', 'DF', 33, NULL, '1993-02-28'::date, 1, 180, 76, 'K06'),
('2007185', '정학철', NULL, NULL, '2005', 'DF', 3, NULL, '1982-11-07'::date, 2, 176, 73, 'K06'),
('2007193', '류병훈', NULL, NULL, '2005', 'DF', 17, NULL, '1986-07-03'::date, 2, 184, 68, 'K06'),
('2011055', '최준홍', NULL, '말머리', '2011', 'DF', 2, NULL, '1988-04-13'::date, 1, 178, 70, 'K06'),
('2011046', '서용혁', NULL, '터프가이', '2011', 'DF', 34, NULL, '1988-07-02'::date, 1, 183, 79, 'K06'),
('2010058', '심재원', NULL, '도날드 덕', '2010', 'DF', 5, NULL, '1987-03-11'::date, 1, 184, 77, 'K06'),
('2007123', '김임생', NULL, NULL, NULL, 'DF', 20, NULL, '1981-11-17'::date, 1, 183, 80, 'K04'),
('2007022', '장형석', NULL, NULL, NULL, 'DF', 36, NULL, '1982-07-07'::date, 1, 181, 72, 'K04'),
('2012058', '박진성', NULL, NULL, NULL, 'DF', 35, NULL, '1993-08-10'::date, 1, 184, 76, 'K04'),
('2009125', '이거룩', NULL, NULL, NULL, 'DF', 4, NULL, '1986-06-26'::date, 1, 183, 77, 'K04'),
('2010001', '이정민', NULL, NULL, NULL, 'DF', 3, NULL, '1987-10-07'::date, 1, 183, 78, 'K04'),
('2012134', '페르난도', NULL, NULL, NULL, 'DF', 44, NULL, '1988-02-24'::date, 1, 178, 74, 'K04'),
('2000094', '김무건', 'KIM, MUGYUN', NULL, NULL, 'DF', NULL, NULL, '1971-03-18'::date, 1, NULL, NULL, 'K03'),
('2007001', '정병지', 'JEONG, BYUNGJI', NULL, '2011', 'GK', 1, NULL, '1980-04-08'::date, 1, 184, 77, 'K03'),
('2011069', '최주호', 'CHOI, JUHO', NULL, '2011', 'GK', 51, NULL, '1992-07-16'::date, 1, 185, 75, 'K03'),
('2007130', '김대희', 'KIM, DAEHEE', NULL, '2010', 'GK', 31, NULL, '1984-04-26'::date, 1, 192, 88, 'K03'),
('2009133', '김준호', 'KIM, JUNHO', NULL, '2009', 'GK', 21, NULL, '1983-04-28'::date, 1, 185, 77, 'K03'),
('2011065', '허인무', 'HEO, INMOO', NULL, '2011', 'GK', 41, NULL, '1988-04-14'::date, 1, 187, 81, 'K03'),
('2011056', '강용', 'KANG, YONG', NULL, '2011', 'DF', 2, NULL, '1989-01-14'::date, 1, 179, 72, 'K03'),
('2007080', '고병운', 'GO, BYUNGWOON', NULL, '2006', 'DF', 16, NULL, '1983-09-28'::date, 1, 180, 73, 'K03'),
('2012069', '정광석', 'JEONG, KWANGSUK', NULL, '2012', 'DF', 39, NULL, '1993-02-12'::date, 1, 183, 72, 'K03'),
('2007002', '정상훈', 'JEONG, SANGHUN', NULL, '2006', 'DF', 13, NULL, '1983-06-08'::date, 1, 183, 76, 'K03'),
('2012062', '정석우', 'JEONG, SEOKWOO', NULL, '2012', 'DF', 32, NULL, '1993-05-06'::date, 1, 181, 72, 'K03'),
('2009139', '정은석', 'JEONG, EUNSEOK', NULL, '2009', 'DF', 5, NULL, '1982-03-14'::date, 1, 185, 80, 'K03'),
('2009030', '최민서', 'CHOI, MINSEO', NULL, '2009', 'DF', 3, NULL, '1986-08-24'::date, 2, 180, 78, 'K03'),
('2012064', '성종현', 'SUNG, JONGHUN', NULL, '2012', 'DF', 34, NULL, '1989-04-02'::date, 1, 178, 74, 'K03'),
('2008468', '싸빅', 'Jasenko Sabitovic', NULL, '2007', 'DF', 4, NULL, '1983-03-29'::date, 1, 185, 78, 'K03'),
('2007277', '오명관', 'OH, MYUNGKWAN', NULL, '2008', 'DF', 15, NULL, '1984-04-29'::date, 1, 185, 76, 'K03'),
('2012063', '김동식', 'KIM, DONGSIK', NULL, '2012', 'MF', 33, NULL, '1989-03-15'::date, 1, 183, 77, 'K03'),
('2012067', '김수길', 'KIM, SOOKIL', NULL, '2012', 'DF', 37, NULL, '1989-04-09'::date, 1, 179, 69, 'K03'),
('2008444', '김승엽', 'KIM, SEUNGYUB', NULL, '2008', 'DF', 12, NULL, '1985-10-12'::date, 1, 180, 74, 'K03'),
('2007101', '김종화', NULL, NULL, NULL, 'DF', 25, NULL, '1984-04-04'::date, 1, 182, 76, 'K03'),
('2007190', '하석주', 'HA, SEOKJU', NULL, '2011', 'DF', 17, NULL, '1978-02-20'::date, 1, 174, 71, 'K03'),
('2010065', '허제정', 'HEO, JAEJUNG', NULL, '2010', 'DF', 29, NULL, '1987-06-02'::date, 1, 175, 70, 'K03'),
('2007096', '홍명보', 'HONG, MYUNGBO', NULL, '2012', 'DF', 20, NULL, '1979-02-12'::date, 1, 181, 72, 'K03'),
('2008472', '정기남', 'JEONG, KINAM', NULL, '2010', 'MF', 6, NULL, '1981-01-18'::date, 1, 174, 72, 'K03'),
('2011059', '정상록', 'JEONG, SANGROK', NULL, '2011', 'MF', 14, NULL, '1989-02-25'::date, 1, 173, 63, 'K03'),
('2011068', '나희근', 'NA, HEEKEUN', NULL, '2011', 'FW', 22, NULL, '1989-05-05'::date, 1, 178, 72, 'K03'),
('2012133', '레오', NULL, NULL, NULL, 'MF', 45, NULL, '1984-10-22'::date, 1, 179, 74, 'K03'),
('2012124', '메도', 'Medvid Ivan', NULL, '2012', 'MF', 44, NULL, '1987-10-13'::date, 1, 180, 78, 'K03'),
('2012068', '최길영', 'CHOI, KILYOUNG', NULL, '2012', 'MF', 38, NULL, '1990-02-04'::date, 1, 172, 64, 'K03'),
('2008203', '최상인', 'CHOI, SANGIN', NULL, '2005', 'DF', 27, NULL, '1986-03-10'::date, 1, 174, 63, 'K03'),
('2011131', '옐라', 'Josko Jelicic', NULL, '2012', 'MF', 8, NULL, '1981-01-05'::date, 1, 184, 79, 'K03'),
('2011061', '유현구', 'YOU, HYUNGOO', NULL, '2011', 'MF', 26, NULL, '1993-01-25'::date, 1, 170, 68, 'K03'),
('2009033', '김기부', 'KIM, KIBU', NULL, '2009', 'MF', 18, NULL, '1986-03-16'::date, 2, 183, 76, 'K03'),
('2012070', '김상인', 'KIM, SANGIN', NULL, '2012', 'DF', 40, NULL, '1989-07-11'::date, 1, 178, 70, 'K03'),
('2011062', '김정운', 'KIM, JUNGWOON', NULL, '2011', 'MF', 19, NULL, '1988-04-19'::date, 1, 178, 70, 'K03'),
('2012071', '김중규', 'KIM, JUNGJYU', NULL, '2012', 'MF', 42, NULL, '1989-06-06'::date, 1, 170, 64, 'K03'),
('2012066', '김창호', 'KIM, CHANGHO', NULL, '2012', 'MF', 36, NULL, '1991-03-15'::date, 1, 175, 75, 'K03'),
('2011063', '이종범', 'LEE, JONGBUM', NULL, '2011', 'MF', 24, NULL, '1988-03-27'::date, 1, 178, 68, 'K03'),
('2012061', '남익경', 'NAM, IKKYUNG', NULL, '2012', 'MF', 30, NULL, '1993-01-26'::date, 1, 177, 70, 'K03'),
('2011064', '윤보영', 'YOON, BOYOUNG', NULL, '2011', 'FW', 23, NULL, '1988-04-29'::date, 1, 177, 63, 'K03'),
('2008443', '김동국', 'KIM, DONGGOOK', NULL, '2008', 'FW', 10, NULL, '1989-04-29'::date, 1, 185, 80, 'K03'),
('2012060', '박종완', 'PARK, JONGWAN', NULL, '2012', 'DF', 28, NULL, '1993-08-05'::date, 1, 188, 82, 'K03'),
('2012059', '김징요', 'Jorge Claudio', NULL, '2011', 'FW', 7, '브라질', '1985-10-01'::date, 1, 174, 70, 'K03'),
('2010044', '이철우', 'LEE, CHULWOO', NULL, '2010', 'FW', 9, NULL, '1987-11-30'::date, 1, 185, 78, 'K03'),
('2011057', '코난', 'Goram Petreski', NULL, '2010', 'FW', 11, NULL, '1982-05-23'::date, 1, 180, 76, 'K03'),
('2000095', '정민규', 'JEONG, MINJYU', NULL, '2012', 'MF', 35, NULL, '1989-09-29'::date, 1, 178, 71, 'K03'),
('2000062', '제형진', 'JAE, HYUNGJIN', NULL, '2012', 'DF', 38, NULL, '1989-06-25'::date, 1, 179, 75, 'K01'),
('2000063', '곽기훈', 'KWAK, KIHOON', NULL, '2012', 'FW', 33, NULL, '1989-11-05'::date, 1, 177, 72, 'K01'),
('2000064', '최민영', 'CHOI, MINYOUNG', NULL, '2010', 'FW', 37, NULL, '1991-03-07'::date, 1, 174, 67, 'K01'),
('2000071', '김회택', NULL, NULL, NULL, 'DF', NULL, NULL, '1976-10-11'::date, 1, NULL, NULL, 'K07'),
('2000072', '서현옥', NULL, NULL, NULL, 'DF', NULL, NULL, '1979-10-27'::date, 1, NULL, NULL, 'K07'),
('2000073', '정상호', NULL, NULL, NULL, 'DF', NULL, NULL, '1974-10-05'::date, 1, NULL, NULL, 'K07'),
('2000074', '최철우', NULL, NULL, NULL, 'DF', NULL, NULL, '1975-09-29'::date, 1, NULL, NULL, 'K07'),
('2012081', '정영광', NULL, NULL, NULL, 'GK', 41, NULL, '1993-06-28'::date, 1, 185, 80, 'K07'),
('2007227', '최종문', NULL, NULL, NULL, 'GK', 1, NULL, '1980-10-02'::date, 1, 185, 76, 'K07'),
('2012088', '염동균', NULL, NULL, NULL, 'GK', 31, NULL, '1993-09-06'::date, 1, 189, 83, 'K07'),
('2012089', '김정래', NULL, NULL, NULL, 'GK', 33, NULL, '1989-11-12'::date, 1, 185, 81, 'K07'),
('2008212', '강철', NULL, NULL, NULL, 'DF', 3, NULL, '1981-11-02'::date, 1, 178, 72, 'K07'),
('2012077', '정강선', NULL, NULL, NULL, 'DF', 37, NULL, '1989-05-23'::date, 1, 180, 73, 'K07'),
('2012083', '정인호', NULL, NULL, NULL, 'DF', 39, NULL, '1993-06-09'::date, 1, 184, 79, 'K07'),
('2007213', '정태영', NULL, NULL, NULL, 'DF', 7, NULL, '1980-11-08'::date, 1, 180, 74, 'K07'),
('2007209', '정현수', NULL, NULL, NULL, 'DF', 21, NULL, '1983-02-14'::date, 1, 176, 74, 'K07'),
('2012084', '정형주', NULL, NULL, NULL, 'DF', 42, NULL, '1989-06-23'::date, 1, NULL, NULL, 'K07'),
('2012085', '정홍철', NULL, NULL, NULL, 'DF', 36, NULL, '1989-06-02'::date, 1, 181, 69, 'K07'),
('2008359', '마시엘', NULL, NULL, NULL, 'DF', 24, NULL, '1982-03-15'::date, 1, 177, 70, 'K07'),
('2011034', '김창원', NULL, NULL, NULL, 'DF', 5, NULL, '1985-07-10'::date, 1, 183, 75, 'K07'),
('2012090', '장경진', NULL, NULL, NULL, 'DF', 34, NULL, '1993-08-31'::date, 1, 184, 82, 'K07'),
('2008425', '주영호', NULL, NULL, NULL, 'DF', 6, NULL, '1985-10-24'::date, 1, 185, 80, 'K07'),
('2012092', '홍성요', NULL, NULL, NULL, 'DF', 28, NULL, '1989-05-26'::date, 1, 184, 78, 'K07'),
('2009115', '정경일', NULL, NULL, NULL, 'MF', 49, NULL, '1990-08-30'::date, 1, 170, 65, 'K07'),
('2011035', '정길식', NULL, NULL, NULL, 'MF', 12, NULL, '1988-08-24'::date, 1, 178, 72, 'K07'),
('2010030', '정남일', NULL, NULL, NULL, 'MF', 4, NULL, '1987-03-14'::date, 1, 182, 76, 'K07'),
('2010032', '정대욱', NULL, NULL, NULL, 'MF', 18, NULL, '1988-04-02'::date, 1, 182, 73, 'K07'),
('2007210', '정도근', NULL, NULL, NULL, 'MF', 10, NULL, '1982-03-02'::date, 2, 181, 69, 'K07'),
('2012078', '정동희', NULL, NULL, NULL, 'MF', 38, NULL, '1993-05-06'::date, 1, 174, 64, 'K07'),
('2007102', '정명곤', NULL, NULL, NULL, 'MF', 2, NULL, '1984-04-15'::date, 1, 177, 73, 'K07'),
('2012079', '정성진', NULL, NULL, NULL, 'MF', 44, NULL, '1989-01-20'::date, 1, 178, 68, 'K07'),
('2012080', '정승현', NULL, NULL, NULL, 'MF', 26, NULL, '1989-08-17'::date, 1, 181, 71, 'K07'),
('2012082', '정요환', NULL, NULL, NULL, 'MF', 25, NULL, '1987-05-23'::date, 1, 170, 62, 'K07'),
('2009100', '정정겸', NULL, NULL, NULL, 'MF', 13, NULL, '1986-06-09'::date, 2, 172, 65, 'K07'),
('2008428', '정종현', NULL, NULL, NULL, 'MF', 11, NULL, '1983-07-10'::date, 1, 173, 68, 'K07'),
('2012086', '노병준', NULL, NULL, NULL, 'MF', 22, NULL, '1989-09-29'::date, 1, 177, 67, 'K07'),
('2012087', '최종우', NULL, NULL, NULL, 'MF', 43, NULL, '1989-04-11'::date, 1, 176, 69, 'K07'),
('2007305', '조진원', NULL, NULL, NULL, 'MF', 9, NULL, '1984-09-27'::date, 1, 176, 75, 'K07'),
('2012132', '실바', NULL, NULL, NULL, 'MF', 45, NULL, '1987-06-20'::date, 1, 173, 67, 'K07'),
('2010031', '윤용구', NULL, NULL, NULL, 'MF', 15, NULL, '1987-08-08'::date, 1, 168, 60, 'K07'),
('2011127', '김반', NULL, NULL, NULL, 'MF', 14, NULL, '1984-10-27'::date, 1, 174, 69, 'K07'),
('2011038', '김영수', NULL, NULL, NULL, 'MF', 30, NULL, '1988-07-30'::date, 1, 175, 65, 'K07'),
('2008423', '임관식', NULL, NULL, NULL, 'MF', 29, NULL, '1985-07-28'::date, 1, 172, 68, 'K07'),
('2011036', '이정호', NULL, NULL, NULL, 'MF', 23, NULL, '1988-04-06'::date, 1, 176, 71, 'K07'),
('2011039', '하기윤', NULL, NULL, NULL, 'MF', 32, NULL, '1992-03-10'::date, 1, 180, 65, 'K07'),
('2010003', '정대철', NULL, NULL, NULL, 'FW', 20, NULL, '1987-08-26'::date, 1, 183, 78, 'K07'),
('2010154', '꼬레아', NULL, NULL, NULL, 'FW', 16, NULL, '1984-08-23'::date, 1, 172, 70, 'K07'),
('2007214', '노상래', NULL, NULL, NULL, 'FW', 8, NULL, '1980-12-15'::date, 1, 175, 74, 'K07'),
('2009149', '성한수', NULL, NULL, NULL, 'FW', 40, NULL, '1986-03-10'::date, 2, 177, 69, 'K07');

 

 

 

실행 순서 4 - 4

INSERT INTO player (player_id, player_name, e_player_name, nickname, join_yyyy, position, back_no, nation, birth_date, solar, height, weight, team_id) VALUES
('2009161', '세자르', NULL, NULL, NULL, 'FW', 17, NULL, '1983-12-09'::date, 1, 180, 78, 'K07'),
('2012032', '조병호', NULL, NULL, NULL, 'FW', 27, NULL, '1987-04-26'::date, 1, 177, 75, 'K07'),
('2011120', '찌코', NULL, NULL, NULL, 'FW', 27, NULL, '1985-01-26'::date, 1, 180, 67, 'K07'),
('2010037', '하성룡', NULL, NULL, NULL, 'FW', 35, NULL, '1992-02-03'::date, 1, 179, 68, 'K07'),
('2012091', '홍복표', NULL, NULL, NULL, 'FW', 19, NULL, '1989-10-28'::date, 1, 182, 73, 'K07'),
('2000081', '김윤환', NULL, NULL, NULL, 'DF', NULL, NULL, '1971-05-24'::date, 1, NULL, NULL, 'K05'),
('2000082', '정은철', NULL, NULL, NULL, 'DF', NULL, NULL, '1978-05-26'::date, 1, NULL, NULL, 'K05'),
('2000083', '김경춘', NULL, NULL, NULL, 'DF', NULL, NULL, '1979-04-14'::date, 1, NULL, NULL, 'K05'),
('2000084', '최동우', NULL, NULL, NULL, 'DF', NULL, NULL, '1980-11-03'::date, 1, NULL, NULL, 'K05'),
('2000085', '전명구', NULL, NULL, NULL, 'DF', NULL, NULL, '1979-03-16'::date, 1, NULL, NULL, 'K05'),
('2000086', '박경치', NULL, NULL, NULL, 'DF', NULL, NULL, '1979-01-06'::date, 1, NULL, NULL, 'K05'),
('2007106', '정이섭', 'JEONG, ISUB', '쾌남', '2012', 'GK', 45, NULL, '1984-04-06'::date, 1, 185, 78, 'K05'),
('2012007', '최관민', 'CHOI, KWANMIN', NULL, '2012', 'GK', 31, NULL, '1989-05-26'::date, 1, 188, 85, 'K05'),
('2008179', '최동우', NULL, NULL, NULL, 'GK', 60, NULL, '1980-11-03'::date, 1, 187, 78, 'K05'),
('2008138', '김용발', 'KIM, YONGBAL', NULL, '2004', 'GK', 18, NULL, '1983-03-15'::date, 1, 183, 77, 'K05'),
('2012006', '김창민', 'KIM, CHANGMIN', '고릴라', '2012', 'GK', 1, NULL, '1990-01-25'::date, 1, 191, 87, 'K05'),
('2010010', '정대건', 'JEONG, DAEKEON', NULL, '2010', 'DF', 26, NULL, '1987-04-27'::date, 1, 183, 78, 'K05'),
('2007159', '정봉현', 'JEONG, BONGHYUN', NULL, '2005', 'MF', 23, NULL, '1984-07-07'::date, 1, 188, 74, 'K05'),
('2012009', '정창민', 'JEONG, CHANGMIN', '야생마', '2012', 'DF', 36, NULL, '1989-09-22'::date, 1, 181, 68, 'K05'),
('2012005', '최동혁', 'CHOI, DONGHYUK', '백호', '2012', 'DF', 23, NULL, '1989-04-18'::date, 1, 185, 78, 'K05'),
('2012012', '백인석', 'BAEK, INSEOK', '떡맨', '2012', 'MF', 40, NULL, '1989-08-08'::date, 1, 179, 72, 'K05'),
('2008391', '서혁수', 'SEO, HYUKSU', '맷돌', '2008', 'DF', 6, NULL, '1983-10-01'::date, 1, 178, 77, 'K05'),
('2012004', '안광호', 'AN, KWANGHO', '왕깡', '2012', 'DF', 15, NULL, '1989-01-10'::date, 1, 190, 78, 'K05'),
('2009076', '임종훈', 'LIM, HONGHUN', '꺼시', '2009', 'DF', 31, NULL, '1986-06-14'::date, 1, 182, 74, 'K05'),
('2007148', '이진철', 'LEE, JINCHEUL', NULL, '2006', 'DF', 4, NULL, '1981-03-26'::date, 1, 187, 75, 'K05'),
('2009061', '한종성', 'HAN, JONGSUNG', NULL, '2009', 'DF', 13, NULL, '1987-01-30'::date, 1, 177, 70, 'K05'),
('2009160', '호제리오', 'Rogerio Prateat', '저승사자', '2009', 'DF', 3, NULL, '1983-03-09'::date, 1, 185, 85, 'K05'),
('2007031', '황승주', NULL, NULL, NULL, 'DF', 98, NULL, '1982-05-09'::date, 1, 176, 68, 'K05'),
('2010023', '고관영', 'KO, KWANYOUNG', '까우', '2010', 'MF', 32, NULL, '1991-12-07'::date, 1, 180, 72, 'K05'),
('2007155', '정경량', 'JEONG, KYUNGRYANG', NULL, '2006', 'MF', 19, NULL, '1983-12-22'::date, 1, 173, 65, 'K05'),
('2010025', '정은익', NULL, NULL, NULL, 'MF', 35, NULL, '1991-03-09'::date, 1, 176, 63, 'K05'),
('2012001', '레오마르', 'Leomar Leiria', '레오', '2012', 'MF', 5, NULL, '1981-06-26'::date, 1, 183, 77, 'K05'),
('2008269', '명재용', 'MYUNG, JAEYOENG', NULL, '2007', 'MF', 7, NULL, '1983-02-26'::date, 2, 173, 63, 'K05'),
('2007149', '변재섭', 'BYUN, JAESUB', '작은탱크', '2007', 'MF', 11, NULL, '1985-09-17'::date, 2, 170, 63, 'K05'),
('2012002', '보띠', 'Raphael JoseBotti Zacarias Sena', 'Botti', '2012', 'MF', 10, NULL, '1991-02-23'::date, 1, 174, 68, 'K05'),
('2011123', '비에라', 'Vieira', NULL, '2011', 'MF', 21, NULL, '1984-02-25'::date, 1, 176, 73, 'K05'),
('2008460', '서동원', 'SEO, DONGWON', NULL, '2008', 'MF', 22, NULL, '1985-08-14'::date, 1, 184, 78, 'K05'),
('2010019', '안대현', 'AN, DAEHYUN', NULL, '2010', 'MF', 25, NULL, '1987-08-20'::date, 1, 179, 72, 'K05'),
('2010018', '양현정', 'YANG, HYUNJUNG', NULL, '2010', 'MF', 14, NULL, '1987-07-25'::date, 1, 176, 72, 'K05'),
('2010022', '유원섭', 'YOU, WONSUOB', '앙마', '2010', 'MF', 37, NULL, '1991-05-24'::date, 1, 180, 77, 'K05'),
('2012008', '김수철', 'KIM, SUCHEUL', NULL, '2012', 'MF', 34, NULL, '1989-05-26'::date, 1, 171, 68, 'K05'),
('2012013', '임다한', 'LIM, DAHAN', '달마', '2012', 'DF', 39, NULL, '1989-07-21'::date, 1, 181, 67, 'K05'),
('2007087', '전경준', 'JEON, KYOUNGJOON', NULL, '2001', 'MF', 16, NULL, '1983-09-10'::date, 1, 178, 68, 'K05'),
('2010021', '이영훈', 'LEE, YOUNGHOON', '깐돌이', '2010', 'MF', 27, NULL, '1991-03-18'::date, 1, 178, 71, 'K05'),
('2011028', '추운기', 'CHOO, WOONKI', '코알라', '2011', 'MF', 17, NULL, '1988-04-03'::date, 1, 173, 69, 'K05'),
('2008393', '하은철', 'HA, EUNCHEUL', NULL, '2008', 'MF', 29, NULL, '1985-06-23'::date, 1, 176, 69, 'K05'),
('2011030', '고민기', 'GO, MINGI', NULL, '2011', 'FW', 24, NULL, '1988-07-01'::date, 1, 178, 70, 'K05'),
('2008143', '정도훈', 'JEONG, DOHOON', '폭격기', '2005', 'FW', 9, NULL, '1980-07-21'::date, 1, 182, 77, 'K05'),
('2012011', '정연건', 'JEONG, YEONGUN', NULL, '2012', 'FW', 44, NULL, '1991-03-12'::date, 1, 188, 77, 'K05'),
('2011002', '정현기', 'JEONG, HYUNKI', NULL, '2011', 'FW', 28, NULL, '1992-03-19'::date, 1, 190, 82, 'K05'),
('2011003', '남궁도', 'NAM, KUNGDO', NULL, '2011', 'FW', 33, NULL, '1992-06-04'::date, 1, 186, 80, 'K05'),
('2010101', '문태혁', 'MOON, TAEHYUK', NULL, '2012', 'FW', 41, NULL, '1993-03-31'::date, 1, 178, 74, 'K05'),
('2008392', '최성배', 'CHOI, SUNGBAE', '흑상어', '2008', 'FW', 8, NULL, '1985-11-28'::date, 2, 181, 76, 'K05'),
('2012125', '에드밀손', 'Edmilson', 'EDY', '2012', 'FW', 20, NULL, '1978-05-29'::date, 1, 184, 79, 'K05'),
('2012003', '쿠키', NULL, NULL, NULL, 'FW', 99, NULL, '1981-04-30'::date, 1, 170, 76, 'K05'),
('2000087', '정은익', 'JEONG, EUNIK', NULL, '2010', 'FW', 35, NULL, '1991-03-09'::date, 1, 176, 65, 'K05');

 

 

 

 

 

 

 

 

실행 순서 4 - 5

INSERT INTO player (player_id, player_name, team_id, e_player_name, nickname, join_yyyy, position, back_no, nation, birth_date, solar, height, weight) VALUES
('2000091', '이순호', 'K03', 'LEE, SOONHO', '', NULL, 'DF', NULL, NULL, '1972-01-10'::date, 1, NULL, NULL),
('2000092', '유동관', 'K03', 'YOU, DONGKWAN', '', NULL, 'DF', NULL, NULL, '1973-05-12'::date, 1, NULL, NULL),
('2000093', '박기동', 'K03', 'PARK, GIDONG', '', NULL, 'DF', NULL, NULL, '1971-05-13'::date, 1, NULL, NULL),
('2011111', '김반코비', 'K02', NULL, NULL, NULL, 'MF', '47', NULL, '1985-02-08'::date, 1, 185, 78),
('2012020', '김선우', 'K02', 'KIM, SUNWOO', '', NULL, 'FW', '33', NULL, '1988-04-01'::date, 1, 174, 68),
('2011074', '김여성', 'K02', 'KIM, YEOSUNG', '', NULL, 'MF', '36', NULL, '1993-01-05'::date, 1, 179, 63),
('2007064', '김용우', 'K02', 'KIM, YONGWOO', '', NULL, 'FW', '27', NULL, '1987-07-20'::date, 1, 175, 70),
('2012019', '김종민', 'K02', 'KIM, JONGMIN', '', NULL, 'MF', '30', NULL, '1993-09-01'::date, 1, 174, 65),
('2008437', '박용훈', 'K02', 'PARK, YONGHOON', '', NULL, 'MF', '9', NULL, '1989-03-11'::date, 1, 175, 67),
('2008436', '김만근', 'K02', 'KIM, MANKEUN', '', NULL, 'FW', '34', NULL, '1987-11-28'::date, 1, 177, 67),
('2007070', '김재민', 'K02', 'KIM, JAEMIN', '', NULL, 'MF', '35', NULL, '1988-05-22'::date, 1, 180, 71),
('2007043', '김현두', 'K02', 'KIM, HYUNDOO', '', NULL, 'MF', '12', NULL, '1983-11-23'::date, 1, 176, 68),
('2012017', '이성용', 'K02', 'LEE, SUNGYONG', '', NULL, 'DF', '20', NULL, '1985-12-25'::date, 1, 173, 70),
('2012018', '하태근', 'K02', 'HA, TAEKEUN', '', NULL, 'MF', '29', NULL, '1993-07-01'::date, 1, 182, 75),
('2012122', '미트로', 'K02', 'Mitrovic Slavisa', '', NULL, 'FW', '19', '보스니아', '1987-07-05'::date, 1, 192, 89),
('2007048', '최건하', 'K02', 'CHOI, KUNHA', '', NULL, 'FW', '18', NULL, '1981-07-25'::date, 1, 180, 75),
('2010168', '산드로', 'K02', 'Sandro Cardoso Dos Santos', '', NULL, 'FW', '13', '브라질', '1990-03-22'::date, 1, 182, 78),
('2012023', '윤화평', 'K02', 'YOON, HWAPYUNG', '', NULL, 'FW', '42', NULL, '1993-03-26'::date, 1, 182, 74),
('2012022', '김관희', 'K02', 'KIM, KWANHEE', '', NULL, 'FW', '39', NULL, '1993-06-29'::date, 1, 180, 70),
('2000051', '김광래', 'K09', NULL, NULL, NULL, 'DF', NULL, NULL, '1974-03-19'::date, 1, NULL, NULL),
('2000052', '김춘석', 'K09', NULL, NULL, NULL, 'DF', NULL, NULL, '1979-02-03'::date, 1, NULL, NULL),
('2000053', '조재흠', 'K09', NULL, NULL, NULL, 'DF', NULL, NULL, '1979-03-26'::date, 1, NULL, NULL),
('2000054', '김영진', 'K09', NULL, NULL, NULL, 'DF', NULL, NULL, '1973-10-27'::date, 1, NULL, NULL),
('2000055', '정귀화', 'K09', NULL, NULL, NULL, 'DF', NULL, NULL, '1980-03-15'::date, 1, NULL, NULL),
('2012094', '최동석', 'K09', NULL, NULL, NULL, 'GK', '1', NULL, '1991-05-03'::date, 1, 190, 89),
('2010125', '백민철', 'K09', NULL, NULL, NULL, 'GK', '21', NULL, '1987-07-28'::date, 1, 185, 78),
('2007236', '조의손', 'K09', NULL, NULL, NULL, 'GK', '44', NULL, '1970-01-12'::date, 1, 192, 87),
('2011018', '우태식', 'K09', NULL, NULL, NULL, 'GK', '31', NULL, '1993-01-08'::date, 1, 185, 75),
('2010117', '정동진', 'K09', NULL, NULL, NULL, 'DF', '4', NULL, '1991-01-29'::date, 1, 182, 74),
('2008414', '정성일', 'K09', NULL, NULL, NULL, 'DF', '19', NULL, '1984-04-13'::date, 1, 178, 75),
('2012093', '정치곤', 'K09', NULL, NULL, NULL, 'DF', '17', NULL, '1993-07-29'::date, 1, 183, 76),
('2012095', '최요셉', 'K09', NULL, NULL, NULL, 'DF', '5', NULL, '1990-12-03'::date, 1, 183, 75),
('2010119', '최용호', 'K09', NULL, NULL, NULL, 'DF', '14', NULL, '1991-03-25'::date, 1, 182, 69),
('2007068', '최정석', 'K09', NULL, NULL, NULL, 'DF', '6', NULL, '1987-04-19'::date, 1, 182, 78),
('2007266', '손현준', 'K09', NULL, NULL, NULL, 'DF', '45', NULL, '1982-03-20'::date, 1, 175, 70),
('2011012', '안성훈', 'K09', NULL, NULL, NULL, 'MF', '2', NULL, '1992-09-11'::date, 1, 176, 63),
('2008420', '김상헌', 'K09', NULL, NULL, NULL, 'DF', '25', NULL, '1985-10-11'::date, 2, 185, 80),
('2012102', '박성호', 'K09', NULL, NULL, NULL, 'DF', '34', NULL, '1996-04-07'::date, 1, 184, 71),
('2007225', '이윤열', 'K09', NULL, NULL, NULL, 'DF', '3', NULL, '1984-04-17'::date, 1, 185, 79),
('2009048', '정도용', 'K09', NULL, NULL, NULL, 'MF', '40', NULL, '1986-05-28'::date, 1, 168, 68),
('2011072', '정민성', 'K09', NULL, NULL, NULL, 'MF', '24', NULL, '1992-05-28'::date, 1, 175, 64),
('2011008', '조재필', 'K09', NULL, NULL, NULL, 'MF', '41', NULL, '1992-05-25'::date, 1, 180, 70),
('2012096', '조현국', 'K09', NULL, NULL, NULL, 'MF', '37', NULL, '1993-03-21'::date, 1, 172, 65),
('2010049', '안드레', 'K09', NULL, NULL, NULL, 'MF', '18', '브라질', '1982-11-16'::date, 1, 172, 69),
('2012097', '안상현', 'K09', NULL, NULL, NULL, 'MF', '33', NULL, '1996-03-05'::date, 1, 176, 67),
('2012098', '우진석', 'K09', NULL, NULL, NULL, 'MF', '39', NULL, '1989-08-26'::date, 1, 176, 70),
('2007133', '유상수', 'K09', NULL, NULL, NULL, 'MF', '43', NULL, '1983-08-28'::date, 2, 175, 67),
('2010048', '김영표', 'K09', NULL, NULL, NULL, 'MF', '12', NULL, '1987-04-23'::date, 1, 176, 66),
('2012100', '김준기', 'K09', NULL, NULL, NULL, 'MF', '36', NULL, '1992-04-25'::date, 1, 183, 74),
('2012101', '김지남', 'K09', NULL, NULL, NULL, 'MF', '42', NULL, '1994-11-21'::date, 1, 183, 68),
('2008413', '박광민', 'K09', NULL, NULL, NULL, 'FW', '23', NULL, '1986-01-08'::date, 1, 180, 70),
('2009051', '박창근', 'K09', NULL, NULL, NULL, 'MF', '27', NULL, '1993-08-10'::date, 2, 170, 63),
('2010118', '이원권', 'K09', NULL, NULL, NULL, 'MF', '13', NULL, '1991-11-08'::date, 1, 173, 65),
('2010120', '정병채', 'K09', NULL, NULL, NULL, 'FW', '15', NULL, '1991-04-14'::date, 1, 180, 72),
('2009046', '정성재', 'K09', NULL, NULL, NULL, 'MF', '8', NULL, '1986-09-17'::date, 2, 178, 72),
('2012119', '뚜따', 'K09', NULL, NULL, NULL, 'FW', '99', '브라질', '1984-06-20'::date, 1, 187, 84),
('2012105', '마르코', 'K09', NULL, NULL, NULL, 'FW', '11', '브라질', '1986-12-03'::date, 1, 175, 77),
('2011005', '최성호', 'K09', NULL, NULL, NULL, 'FW', '30', NULL, '1992-07-27'::date, 1, 187, 73),
('2011108', '최윤화', 'K09', NULL, NULL, NULL, 'MF', '16', NULL, '1988-06-13'::date, 1, 175, 67),
('2009047', '최정환', 'K09', NULL, NULL, NULL, 'FW', '20', NULL, '1987-01-14'::date, 1, 178, 70),
('2009005', '왕정현', 'K09', NULL, NULL, NULL, 'FW', '28', NULL, '1986-08-30'::date, 2, 181, 73),
('2012099', '김정수', 'K09', NULL, NULL, NULL, 'FW', '7', NULL, '1990-01-08'::date, 1, 184, 74),
('2012103', '김원광', 'K09', NULL, NULL, NULL, 'FW', '22', NULL, '1995-08-23'::date, 1, 183, 68),
('2009044', '진순진', 'K09', NULL, NULL, NULL, 'MF', '26', NULL, '1984-03-01'::date, 2, 180, 78),
('2010053', '이태욱', 'K09', NULL, NULL, NULL, 'FW', '9', NULL, '1991-03-13'::date, 1, 173, 66),
('2012104', '한동원', 'K09', NULL, NULL, NULL, 'FW', '32', NULL, '1996-04-06'::date, 1, 174, 61),
('2011004', '한정화', 'K09', NULL, NULL, NULL, 'FW', '29', NULL, '1992-10-31'::date, 1, 173, 63),
('2010164', '히카르도', 'K09', NULL, NULL, NULL, 'MF', '10', '브라질', '1986-06-08'::date, 1, 189, 71);

 

 

 

 

실행 순서 4 - 6

INSERT INTO player (player_id, player_name, team_id, e_player_name, nickname, join_yyyy, position, back_no, nation, birth_date, solar, height, weight) VALUES
('2011082', '권정혁', 'K01', 'KWON, JUNGHYUK', NULL, '2011', 'GK', 1, NULL, '1988-08-02'::date, 1, 195, 80),
('2009070', '최창주', 'K01', 'CHOI, CHANGZOO', NULL, '2009', 'GK', 40, NULL, '1982-09-30'::date, 1, 187, 86),
('2007020', '서동명', 'K01', 'SEO, DONGMYUNG', NULL, '2012', 'GK', 21, NULL, '1984-05-04'::date, 1, 196, 94),
('2008410', '양지원', 'K01', 'YANG, JIWON', NULL, '2008', 'GK', 45, NULL, '1984-04-28'::date, 1, 181, 75),
('2012039', '이무림', 'K01', 'LEE, MOOLIM', NULL, '2012', 'GK', 31, NULL, '1989-04-15'::date, 1, 185, 79),
('2012034', '정윤구', 'K01', 'JEONG, YOONGOO', NULL, '2012', 'DF', 20, NULL, '1989-09-01'::date, 1, 182, 75),
('2011106', '끌레베르', 'K01', 'Cleber Arild', NULL, '2011', 'DF', 3, '브라질', '1979-01-21'::date, 1, 186, 79),
('2011080', '최경삼', 'K01', 'CHOI, GYUNGSAM', NULL, '2011', 'DF', 25, NULL, '1988-06-06'::date, 1, 188, 74),
('2007004', '최종욱', 'K01', 'CHOI, JONGWOOK', NULL, '2007', 'DF', 29, NULL, '1985-01-11'::date, 1, 185, 74),
('2012035', '변성환', 'K01', 'BYUN, SUNGHWAN', NULL, '2012', 'DF', 23, NULL, '1989-12-22'::date, 1, 176, 69),
('2008366', '손상호', 'K01', 'SON, SANGHO', NULL, '2007', 'DF', 28, NULL, '1984-05-04'::date, 1, 187, 78),
('2012044', '유재형', 'K01', 'YOU, JAEHYUNG', NULL, '2012', 'DF', 39, NULL, '1987-08-24'::date, 1, 180, 79),
('2011077', '김세권', 'K01', 'KIM, SAEKWON', NULL, '2011', 'DF', 4, NULL, '1988-06-26'::date, 1, 184, 80),
('2009069', '하성용', 'K01', 'HA, SUNGYONG', NULL, '2009', 'DF', 43, NULL, '1986-10-05'::date, 1, 179, 75),
('2010082', '한정일', 'K01', 'HAN, JEUNGIL', NULL, '2010', 'DF', 41, NULL, '1987-03-03'::date, 1, 172, 65),
('2010054', '정건형', 'K01', 'JEONG, KUNHYUNG', NULL, '2010', 'MF', 17, NULL, '1989-09-11'::date, 1, 176, 70),
('2009058', '정도균', 'K01', 'JEONG, DOKYUN', NULL, '2009', 'MF', 6, NULL, '1987-01-13'::date, 1, 184, 78),
('2011083', '최기욱', 'K01', 'CHOI, KIWOOK', NULL, '2011', 'MF', 18, NULL, '1988-12-22'::date, 1, 175, 68),
('2012028', '최진섭', 'K01', 'CHOI, JINSUP', NULL, '2012', 'MF', 2, NULL, '1987-03-11'::date, 1, 179, 68),
('2011079', '서덕규', 'K01', 'SEO, DOUKGUY', NULL, '2011', 'DF', 5, NULL, '1988-10-22'::date, 1, 182, 72),
('2012130', '에디', 'K01', 'Edmilson Alves', NULL, '2012', 'MF', 7, '브라질', '1986-02-17'::date, 1, 182, 70),
('2009055', '김길용', 'K01', 'KIM, KILYONG', NULL, '2009', 'MF', 22, NULL, '1986-03-30'::date, 2, 183, 78),
('2012036', '김윤섭', 'K01', 'KIM, YOONSUB', NULL, '2012', 'MF', 26, NULL, '1989-07-30'::date, 1, 184, 77),
('2012029', '김천수', 'K01', 'KIM, CHUNSU', NULL, '2012', 'MF', 9, NULL, '1991-07-09'::date, 1, 174, 65),
('2012033', '장성욱', 'K01', 'JANG, SUNGWOOK', NULL, '2012', 'MF', 19, NULL, '1989-09-01'::date, 1, 174, 71),
('2007023', '장철민', 'K01', 'JANG, CHULMIN', NULL, '2007', 'MF', 24, NULL, '1982-05-19'::date, 1, 179, 76),
('2011084', '전광철', 'K01', 'JEON, KWANGCHEOL', NULL, '2011', 'MF', 34, NULL, '1992-07-16'::date, 1, 186, 74),
('2012045', '전재운', 'K01', 'JEON, JAEWOON', NULL, '2012', 'MF', 42, NULL, '1991-06-05'::date, 1, 177, 67),
('2007008', '박정수', 'K01', 'PARK, JEONGSOO', NULL, '2003', 'MF', 8, NULL, '1979-11-20'::date, 1, 170, 61),
('2012042', '박주영', 'K01', 'PARK, HUYOUNG', NULL, '2012', 'MF', 36, NULL, '1989-05-03'::date, 1, 172, 65),
('2012040', '김원희', 'K01', 'KIM, WONHEE', NULL, '2012', 'MF', 32, NULL, '1993-04-17'::date, 1, 178, 71),
('2012041', '곽기훈', 'K01', NULL, NULL, NULL, 'FW', 33, NULL, '1989-11-05'::date, 1, 177, 72),
('2007010', '정현석', 'K01', 'JEONG, HYUNSEOK', NULL, '2011', 'FW', 16, NULL, '1977-05-05'::date, 1, 178, 70),
('2011105', '마르코스', 'K01', 'Marcos Antonio', NULL, '2011', 'FW', 44, '브라질', '1987-04-07'::date, 1, 170, 73),
('2010045', '최규선', 'K01', 'CHOI, GYUSUN', NULL, '2010', 'FW', 15, NULL, '1991-09-24'::date, 1, 182, 66),
('2012129', '알리송', 'K01', 'Alison Barros Moraes', NULL, NULL, 'FW', 14, '브라질', '1992-06-30'::date, 1, 171, 60),
('2012038', '김태유', 'K01', 'KIM, TAEYOO', NULL, '2012', 'FW', 30, NULL, '1989-10-01'::date, 1, 175, 64),
('2012030', '박성훈', 'K01', NULL, NULL, NULL, 'FW', 10, NULL, '1989-07-04'::date, 1, 187, 83),
('2012037', '이인석', 'K01', 'LEE, INSUK', NULL, '2012', 'FW', 27, NULL, '1989-08-07'::date, 1, 181, 74),
('2011104', '파울링뇨', 'K01', 'Marcos Paulo Paulrini', NULL, '2011', 'FW', 11, '브라질', '1987-03-04'::date, 1, 174, 75),
('2012031', '현영민', 'K01', 'HYUN, YOUNGMIN', NULL, '2012', 'FW', 13, NULL, '1989-12-25'::date, 1, 179, 73),
('2000061', '홍인기', 'K01', 'HONG, INKI', NULL, '2008', 'DF', 35, NULL, '1989-03-15'::date, 1, 182, 75),
('2007114', '정기동', 'K04', NULL, NULL, NULL, 'MF', 6, NULL, '1981-01-12'::date, 1, 171, 66),
('2010005', '정기형', 'K04', NULL, NULL, NULL, 'MF', 19, NULL, '1987-07-10'::date, 1, 173, 64),
('2012055', '정정현', 'K04', NULL, NULL, NULL, 'MF', 32, NULL, '1989-04-01'::date, 1, 176, 68),
('2007122', '정한윤', 'K04', NULL, NULL, NULL, 'MF', 14, NULL, '1984-07-11'::date, 1, 185, 74),
('2007137', '남기일', 'K04', NULL, NULL, NULL, 'MF', 29, NULL, '1984-08-17'::date, 1, 177, 69),
('2012131', '무스타파', 'K04', NULL, NULL, NULL, 'MF', 77, NULL, '1985-01-08'::date, 1, 180, 73),
('2012056', '최정주', 'K04', NULL, NULL, NULL, 'MF', 33, NULL, '1989-06-26'::date, 1, 177, 73),
('2010004', '조현호', 'K04', NULL, NULL, NULL, 'MF', 22, NULL, '1987-07-07'::date, 1, 183, 71),
('2007125', '윤정춘', 'K04', NULL, NULL, NULL, 'MF', 17, NULL, '1983-02-18'::date, 1, 173, 66),
('2011103', '장경호', 'K04', NULL, NULL, NULL, 'MF', 39, NULL, '1993-02-23'::date, 1, 174, 66),
('2008209', '이문식', 'K04', NULL, NULL, NULL, 'MF', 10, NULL, '1981-10-23'::date, 1, 173, 66),
('2008457', '곽경근', 'K04', 'GWAK, JYUNGKEUN', '골든맨', '2008', 'FW', 9, NULL, '1982-10-10'::date, 1, 184, 81),
('2012120', '다보', 'K04', 'Chelck Oumar Dabo', NULL, '2012', 'FW', 63, NULL, NULL, 1, 183, 76),
('2007126', '최성철', 'K04', 'CHOI, SUNGCHUL', '코미디언', '2007', 'FW', 28, NULL, '1985-03-16'::date, 1, 190, 78),
('2007153', '비탈리', 'K04', 'VITALIY', NULL, '2012', 'FW', 24, NULL, '1979-05-04'::date, 1, 183, 74),
('2009026', '안승인', 'K04', 'AN, SEUNGIN', '안뽕', '2009', 'FW', 13, NULL, '1983-03-14'::date, 1, 182, 75),
('2011019', '윤원철', 'K04', NULL, NULL, NULL, 'FW', 8, NULL, '1989-01-06'::date, 1, 184, 75),
('2009027', '김성재', 'K04', 'KIM, SUNGJAE', '까치,돌쇠', '2009', 'FW', 11, NULL, '1986-05-16'::date, 1, 178, 67),
('2007135', '김원식', 'K04', 'KIM, WONSHIK', '뺀, 밥식이', '2006', 'FW', 27, NULL, '1983-05-16'::date, 1, 172, 64),
('2012057', '김종민', 'K04', 'KIM, JONGMIN', NULL, '2012', 'FW', 34, NULL, '1993-08-01'::date, 1, 184, 77),
('2011020', '박필석', 'K04', 'PARK, PILSUK', '장신', '2011', 'FW', 18, NULL, '1988-07-23'::date, 1, 190, 83),
('2010084', '제프유', 'K04', 'JEFF JI YOUNG', NULL, '2011', 'FW', 16, '미국', '1988-10-30'::date, 1, 184, 76),
('2000026', '롤란', 'K04', NULL, NULL, '2010', 'FW', NULL, '리투아니아', NULL, NULL, 184, 81),
('2000027', '셀라하틴', 'K04', 'Selahattin', NULL, '2012', 'FW', 11, '김탈리아', NULL, NULL, 180, 75),
('2000031', '차경복', 'K08', NULL, NULL, '2008', 'DF', NULL, NULL, '1977-01-10'::date, 1, NULL, NULL),
('2000032', '정학범', 'K08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('2000033', '안익수', 'K08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('2000034', '차상광', 'K08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('2009045', '권찬수', 'K08', 'KWON, CHANSOO', NULL, NULL, 'GK', 21, NULL, '1984-05-30'::date, 2, 183, 77),
('2012107', '정경두', 'K08', 'JEONG, KYOUNGDOO', NULL, NULL, 'GK', 41, NULL, NULL, 1, 194, 76),
('2007255', '정해운', 'K08', 'JEONG, HAEWOON', NULL, NULL, 'GK', 1, NULL, '1983-12-25'::date, 2, 185, 79),
('2009101', '양영민', 'K08', 'YANG, YOUNGMIN', NULL, NULL, 'GK', 31, NULL, '1984-07-19'::date, 1, 190, 80),
('2011087', '가이모토', 'K08', 'KAIMOTO KOJIRO', NULL, NULL, 'DF', 3, NULL, '1987-10-14'::date, 1, 182, 77),
('2012108', '정두영', 'K08', 'JEONG, DOYOUNG', NULL, NULL, 'DF', 30, NULL, '1990-10-07'::date, 1, 181, 75),
('2012118', '정명휘', 'K08', 'JEONG, MYONGHWI', NULL, NULL, 'DF', 37, NULL, '1991-05-08'::date, 1, 185, 76),
('2007329', '정영철', 'K08', 'JEONG, YOUNGCHUL', NULL, NULL, 'DF', 5, NULL, '1986-06-30'::date, 1, 183, 80),
('2007259', '정정재', 'K08', 'JEONG, JUNGJAE', NULL, NULL, 'DF', 13, NULL, '1984-05-22'::date, 2, 184, 80),
('2007186', '정현수', 'K08', 'JEONG, HYUNSOO', NULL, NULL, 'DF', 15, NULL, '1983-03-13'::date, 2, 186, 80),
('2007089', '노태경', 'K08', 'NO, TAEKYOUNG', NULL, NULL, 'DF', 25, NULL, '1982-04-22'::date, 1, 175, 68),
('2009098', '문삼진', 'K08', 'MOON, SAMJIN', NULL, NULL, 'DF', 2, NULL, '1983-03-03'::date, 1, 173, 68),
('2012111', '민경인', 'K08', 'MIN, KYUNGIN', NULL, NULL, 'DF', 12, NULL, '1989-05-09'::date, 1, 177, 71),
('2011091', '최종남', 'K08', 'CHOI, JONGNAM', NULL, NULL, 'DF', 34, NULL, '1986-11-17'::date, 1, 182, 76),
('2007055', '최충균', 'K08', 'CHOI, CHOONGKYUN', NULL, NULL, 'DF', 20, NULL, '1983-06-20'::date, 1, 184, 70),
('2010034', '배진수', 'K08', 'BAE, JINSOO', NULL, NULL, 'DF', 38, NULL, '1986-01-25'::date, 1, 178, 72),
('2008471', '김영진', 'K08', 'KIM, YOUNGJIN', NULL, NULL, 'DF', 23, NULL, '1982-03-27'::date, 2, 180, 75),
('2008399', '임규식', 'K08', 'LIM, KYUSIK', NULL, NULL, 'DF', 27, NULL, '1985-05-09'::date, 1, 182, 75),
('2012106', '곽치국', 'K08', 'KWAK, CHIGOOG', NULL, NULL, 'MF', 32, NULL, '1989-04-22'::date, 1, 170, 68),
('2009095', '정상식', 'K08', 'JEONG, SANGSIK', NULL, NULL, 'MF', 4, NULL, '1986-12-17'::date, 1, 184, 71),
('2011086', '정용희', 'K08', 'JEONG, YONGHEE', NULL, NULL, 'MF', 18, NULL, '1988-10-15'::date, 1, 178, 70),
('2012109', '노규영', 'K08', NULL, NULL, NULL, 'MF', 33, NULL, '1988-04-29'::date, 1, 180, 83),
('2010126', '최강조', 'K08', 'CHOI, KANGJO', NULL, NULL, 'MF', 6, NULL, '1990-01-24'::date, 1, 165, 57),
('2008171', '최남열', 'K08', 'CHOI, NAMRYUL', NULL, NULL, 'MF', 8, NULL, '1980-05-07'::date, 2, 178, 70),
('2011088', '백영철', 'K08', 'BAEK, YOUNGCHUL', NULL, NULL, 'MF', 22, NULL, '1988-11-11'::date, 1, 177, 71),
('2007242', '조태용', 'K08', 'CHO, TAEYONG', NULL, NULL, 'MF', 7, NULL, '1980-10-11'::date, 1, 174, 67),
('2012117', '올리베', 'K08', 'Alcir de Oliveira fonseca', NULL, NULL, 'MF', 29, '브라질', '1987-11-14'::date, 1, 175, 73),
('2011128', '김리네', 'K08', 'Ricardo Irineu', NULL, NULL, 'MF', 26, '브라질', '1987-07-12'::date, 1, 172, 69),
('2012128', '쟈스민', 'K08', 'Jasmin Mujidza', NULL, NULL, 'MF', 33, '크로아티아', '1984-03-02'::date, 1, 180, 78),
('2012114', '전재호', 'K08', 'CHUN, JAEHO', NULL, NULL, 'MF', 14, NULL, '1989-08-08'::date, 1, 168, 64),
('2008131', '김진호', 'K08', 'KIM, JINHO', NULL, NULL, 'MF', 11, NULL, '1983-08-02'::date, 1, 174, 68),
('2012115', '이낙훈', 'K08', 'LEE, NAKHOON', NULL, NULL, 'MF', 35, NULL, '1989-12-28'::date, 1, 172, 62),
('2007100', '홍도표', 'K08', 'HONG, DOPYO', NULL, NULL, 'MF', 9, NULL, '1983-07-24'::date, 1, 173, 66),
('2010127', '정대의', 'K08', 'JEONG, DAEEUI', NULL, NULL, 'FW', 19, NULL, '1987-05-30'::date, 1, 174, 70),
('2009084', '정우재', 'K08', 'JEONG, WOOJAE', NULL, NULL, 'FW', 24, NULL, '1986-09-13'::date, 1, 173, 71),
('2007192', '샤샤', 'K08', 'Drakulic sasa', NULL, NULL, 'FW', 10, NULL, '1982-08-28'::date, 1, 190, 84),
('2012112', '서관수', 'K08', 'SEO, KWANSOO', NULL, NULL, 'FW', 17, NULL, '1990-02-25'::date, 1, 179, 74),
('2011095', '김성운', 'K08', 'KIM, SUNGWOON', NULL, NULL, 'FW', 40, NULL, '1988-12-25'::date, 1, 173, 64),
('2012113', '김정운', 'K08', 'KIM, JUNGWOON', NULL, NULL, 'FW', 28, NULL, '1993-03-14'::date, 1, 170, 68),
('2011094', '장동현', 'K08', 'JANG, DONGHYUN', NULL, NULL, 'FW', 39, NULL, '1992-03-19'::date, 1, 178, 67),
('2007250', '황연석', 'K08', 'HWANG, YOUNSUCK', NULL, NULL, 'FW', 16, NULL, '1983-10-17'::date, 1, 192, 81);

 

실행 순서 4 - 7

 

INSERT INTO player (player_id, player_name, team_id, e_player_name, nickname, join_yyyy, position, back_no, nation, birth_date, solar, height, weight) VALUES
('2000041', '정호', 'K02', 'JEONG, HO', NULL, NULL, 'DF', NULL, NULL, '1974-11-24'::date, 1, NULL, NULL),
('2000042', '왕선재', 'K02', 'WANG, SUNJAE', NULL, NULL, 'DF', NULL, NULL, '1979-03-16'::date, 1, NULL, NULL),
('2000043', '코샤', 'K02', 'Marco Antonio Alvarez Ferreira', NULL, NULL, 'DF', NULL, '브라질', '1970-07-20'::date, 1, NULL, NULL),
('2000044', '윤성효', 'K02', 'YOON, SUNGHYO', NULL, NULL, 'DF', NULL, NULL, '1972-05-18'::date, 1, NULL, NULL),
('2007067', '정광수', 'K02', 'JEONG, GWANGSOO', NULL, NULL, 'GK', 41, NULL, '1987-03-10'::date, 1, 182, 79),
('2009004', '최호진', 'K02', 'CHOI, HOJIN', NULL, NULL, 'GK', 31, NULL, '1986-10-22'::date, 1, 190, 82),
('2007203', '조범철', 'K02', 'CHO, BUMCHUL', NULL, NULL, 'GK', 21, NULL, '1980-09-27'::date, 2, 185, 85),
('2007035', '김운재', 'K02', 'KIM, WOONJAE', NULL, NULL, 'GK', 1, NULL, '1983-04-26'::date, 1, 182, 82),
('2008429', '정영선', 'K02', 'JEONG, YOUNGSUN', NULL, NULL, 'DF', 16, NULL, '1985-04-03'::date, 1, 184, 81),
('2012021', '정유진', 'K02', 'JEONG, YOUJIN', NULL, NULL, 'DF', 37, NULL, '1993-06-19'::date, 1, 188, 76),
('2011073', '손승준', 'K02', 'SON, SEUNGJUN', NULL, NULL, 'DF', 32, NULL, '1992-05-16'::date, 1, 186, 72),
('2007007', '조홍기', 'K02', 'CHO, HONGGI', NULL, NULL, 'DF', 15, NULL, '1978-05-04'::date, 1, 175, 66),
('2012027', '안동원', 'K02', 'AN, DONGWON', NULL, NULL, 'DF', 49, NULL, '1992-09-27'::date, 1, 184, 78),
('2012024', '김강진', 'K02', 'KIM, KANGJIN', NULL, NULL, 'DF', 43, NULL, '1996-04-25'::date, 1, 181, 65),
('2007036', '김병근', 'K02', 'KIM, BYOUNGKEUN', NULL, NULL, 'DF', 3, NULL, '1983-04-28'::date, 1, 175, 63),
('2012026', '김태권', 'K02', 'KIM, TAE-KWON', NULL, NULL, 'DF', 46, NULL, '1990-07-14'::date, 1, 180, 75),
('2012014', '김병국', 'K02', 'KIM, BYUNGKOOK', NULL, NULL, 'DF', 2, NULL, '1991-07-01'::date, 1, 183, 78),
('2011075', '김성환', 'K02', 'KIM, SUNGHWAN', NULL, NULL, 'DF', 5, NULL, '1992-04-09'::date, 1, 183, 75),
('2012123', '가비', 'K02', 'Gabriel Popescu', NULL, NULL, 'MF', 10, '루마니아', '1983-12-25'::date, 1, 177, 74),
('2010089', '강대희', 'K02', NULL, NULL, NULL, 'MF', 26, NULL, '1987-02-02'::date, 1, 174, 65),
('2007051', '고종수', 'K02', 'KO, JONGSU', NULL, NULL, 'MF', 22, NULL, '1988-10-30'::date, 1, 176, 70),
('2012015', '고창현', 'K02', 'KO, CHANGHYUN', NULL, NULL, 'MF', 8, NULL, '1993-09-15'::date, 1, 170, 64),
('2009089', '정기범', 'K02', 'JEONG, KIBUM', NULL, NULL, 'MF', 28, NULL, '1986-08-14'::date, 1, 173, 65),
('2009083', '정동현', 'K02', 'JEONG, DONGHYUN', NULL, NULL, 'MF', 25, NULL, '1990-08-17'::date, 1, 175, 72),
('2011071', '정두현', 'K02', 'JEONG, DOOHYUN', NULL, NULL, 'MF', 4, NULL, '1992-07-14'::date, 1, 175, 67),
('2012025', '정준', 'K02', 'JEONG, JUN', NULL, NULL, 'MF', 44, NULL, '1996-12-09'::date, 1, 170, 65),
('2007040', '정진우', 'K02', 'JEONG, JINWOO', NULL, NULL, 'DF', 7, NULL, '1985-10-09'::date, 1, 179, 72),
('2007069', '데니스', 'K02', 'Laktionov Denis', NULL, NULL, 'FW', 11, '러시아', '1987-09-04'::date, 1, 176, 71),
('2007274', '서정원', 'K02', 'SEO, JUNGWON', NULL, NULL, 'FW', 14, NULL, '1980-12-17'::date, 1, 173, 66),
('2012016', '손대호', 'K02', 'SON, DAEHO', NULL, NULL, 'DF', 17, NULL, '1991-09-11'::date, 1, 186, 79),
('2011070', '오규찬', 'K02', 'OH, GUCHAN', NULL, NULL, 'MF', 24, NULL, '1992-08-28'::date, 1, 178, 71),
('2012135', '윤원일', 'K02', NULL, NULL, NULL, 'MF', 45, NULL, '1993-03-31'::date, 1, 176, 70),
('2009131', '김동욱', 'K02', 'KIM, DONGWOOK', NULL, NULL, 'MF', 40, NULL, '1986-04-10'::date, 1, 176, 68),
('2010901', '장성철', 'K11', NULL, NULL, NULL, 'MF', 27, NULL, '1991-03-09'::date, 1, 176, 75),
('2010902', '장윤정', 'K11', NULL, NULL, NULL, 'DF', 17, NULL, '1993-03-14'::date, 1, 173, 63),
('2010903', '장서연', 'K11', NULL, NULL, NULL, 'FW', 7, NULL, '1995-01-29'::date, 1, 180, 60),
('2009901', '고규억', 'K12', NULL, NULL, NULL, 'DF', 29, NULL, '1994-08-14'::date, 1, 175, 70),
('2009902', '장재우', 'K12', NULL, NULL, NULL, 'FW', 12, NULL, '1987-02-28'::date, 1, 172, 63),
('2008901', '오재진', 'K13', NULL, NULL, NULL, 'DF', 49, NULL, '1992-07-23'::date, 1, 173, 72),
('2008902', '선원길', 'K13', NULL, NULL, NULL, 'GK', 46, NULL, '1996-04-26'::date, 1, 174, 66),
('2008903', '안소정', 'K13', NULL, NULL, NULL, 'FW', 38, NULL, '1997-10-24'::date, 1, 174, 63),
('2007901', '주시형', 'K14', NULL, NULL, NULL, 'DF', 33, NULL, '1992-11-11'::date, 1, 170, 72),
('2007902', '홍종하', 'K14', NULL, NULL, NULL, 'MF', 32, NULL, '1988-12-21'::date, 1, 169, 74),
('2010801', '오춘식', 'K15', NULL, NULL, NULL, 'MF', 22, NULL, '1988-03-08'::date, 1, 168, 75),
('2010802', '박창우', 'K15', NULL, NULL, NULL, 'DF', 13, NULL, '1989-05-17'::date, 1, 177, 68),
('2010803', '박진하', 'K15', NULL, NULL, NULL, 'FW', 11, NULL, '1989-01-09'::date, 1, 181, 62);

 

 

실행 순서 5 - 1

 

INSERT INTO schedule (stadium_id, sche_date, gubun, hometeam_id, awayteam_id, home_score, away_score) VALUES
('D01', '2012-09-11', 'False'::VARCHAR, 'K07', 'K05', NULL, NULL),
('B05', '2012-09-11', 'False'::VARCHAR, 'K09', 'K01', NULL, NULL),
('B04', '2012-09-11', 'False'::VARCHAR, 'K02', 'K08', NULL, NULL),
('B01', '2012-09-11', 'False'::VARCHAR, 'K04', 'K03', NULL, NULL),
('D02', '2012-09-11', 'False'::VARCHAR, 'K10', 'K06', NULL, NULL),
('C02', '2012-09-14', 'False'::VARCHAR, 'K06', 'K04', NULL, NULL),
('C06', '2012-09-14', 'False'::VARCHAR, 'K03', 'K09', NULL, NULL),
('B02', '2012-09-14', 'False'::VARCHAR, 'K08', 'K01', NULL, NULL),
('D01', '2012-09-14', 'False'::VARCHAR, 'K07', 'K02', NULL, NULL),
('D03', '2012-09-15', 'False'::VARCHAR, 'K05', 'K10', NULL, NULL),
('D02', '2012-09-18', 'False'::VARCHAR, 'K10', 'K02', NULL, NULL),
('B02', '2012-09-18', 'False'::VARCHAR, 'K08', 'K07', NULL, NULL),
('B05', '2012-09-18', 'False'::VARCHAR, 'K09', 'K06', NULL, NULL),
('D03', '2012-09-18', 'False'::VARCHAR, 'K05', 'K04', NULL, NULL),
('B04', '2012-09-25', 'False'::VARCHAR, 'K02', 'K10', NULL, NULL),
('C06', '2012-09-25', 'False'::VARCHAR, 'K03', 'K01', NULL, NULL),
('B01', '2012-09-25', 'False'::VARCHAR, 'K04', 'K05', NULL, NULL),
('D01', '2012-09-25', 'False'::VARCHAR, 'K07', 'K08', NULL, NULL),
('B05', '2012-09-25', 'False'::VARCHAR, 'K09', 'K06', NULL, NULL),
('D01', '2012-10-19', 'False'::VARCHAR, 'K07', 'K02', NULL, NULL),
('C06', '2012-10-19', 'False'::VARCHAR, 'K03', 'K09', NULL, NULL),
('D02', '2012-10-20', 'False'::VARCHAR, 'K10', 'K05', NULL, NULL),
('C02', '2012-10-20', 'False'::VARCHAR, 'K06', 'K04', NULL, NULL),
('C06', '2012-10-23', 'False'::VARCHAR, 'K03', 'K04', NULL, NULL),
('D03', '2012-10-23', 'False'::VARCHAR, 'K05', 'K07', NULL, NULL),
('C02', '2012-10-23', 'False'::VARCHAR, 'K06', 'K10', NULL, NULL),
('B02', '2012-10-23', 'False'::VARCHAR, 'K08', 'K02', NULL, NULL),
('D01', '2012-10-26', 'False'::VARCHAR, 'K07', 'K06', NULL, NULL),
('D02', '2012-10-27', 'False'::VARCHAR, 'K10', 'K03', NULL, NULL),
('B01', '2012-10-27', 'False'::VARCHAR, 'K04', 'K01', NULL, NULL),
('B05', '2012-10-27', 'False'::VARCHAR, 'K09', 'K08', NULL, NULL),
('B04', '2012-10-27', 'False'::VARCHAR, 'K02', 'K05', NULL, NULL),
('B04', '2012-10-30', 'False'::VARCHAR, 'K02', 'K04', NULL, NULL),
('D02', '2012-10-30', 'False'::VARCHAR, 'K10', 'K08', NULL, NULL),
('C06', '2012-11-02', 'N'::VARCHAR, 'K03', 'K07', NULL, NULL),
('B05', '2012-11-03', 'N'::VARCHAR, 'K09', 'K04', NULL, NULL),
('C02', '2012-11-03', 'N'::VARCHAR, 'K06', 'K02', NULL, NULL),
('B02', '2012-11-03', 'N'::VARCHAR, 'K08', 'K05', NULL, NULL),
('D03', '2012-11-06', 'N'::VARCHAR, 'K05', 'K06', NULL, NULL),
('D01', '2012-11-06', 'N'::VARCHAR, 'K07', 'K01', NULL, NULL),
('D02', '2012-11-06', 'N'::VARCHAR, 'K10', 'K09', NULL, NULL),
('B01', '2012-11-06', 'N'::VARCHAR, 'K04', 'K08', NULL, NULL),
('B04', '2012-11-06', 'N'::VARCHAR, 'K02', 'K03', NULL, NULL),
('C06', '2012-11-09', 'N'::VARCHAR, 'K03', 'K05', NULL, NULL),
('B05', '2012-11-10', 'N'::VARCHAR, 'K09', 'K07', NULL, NULL),
('B01', '2012-11-10', 'N'::VARCHAR, 'K04', 'K10', NULL, NULL),
('B02', '2012-11-10', 'N'::VARCHAR, 'K08', 'K06', NULL, NULL),
('D01', '2012-11-13', 'N'::VARCHAR, 'K07', 'K04', NULL, NULL),
('C02', '2012-11-13', 'N'::VARCHAR, 'K06', 'K03', NULL, NULL),
('B04', '2012-11-13', 'N'::VARCHAR, 'K02', 'K09', NULL, NULL),
('D03', '2012-11-13', 'N'::VARCHAR, 'K05', 'K01', NULL, NULL),
('B05', '2012-11-17', 'N'::VARCHAR, 'K09', 'K05', NULL, NULL),
('D02', '2012-11-17', 'N'::VARCHAR, 'K10', 'K07', NULL, NULL),
('C06', '2012-11-17', 'N'::VARCHAR, 'K03', 'K08', NULL, NULL),
('B01', '2012-11-17', 'N'::VARCHAR, 'K04', 'K02', NULL, NULL),
('C02', '2012-05-01', 'Y', 'K06', 'K10', 2, 0),
('B04', '2012-05-05', 'Y', 'K02', 'K01', 1, 2),
('B05', '2012-05-05', 'Y', 'K09', 'K08', 1, 3),
('B02', '2012-05-12', 'Y', 'K08', 'K01', 1, 1),
('C02', '2012-07-07', 'Y', 'K06', 'K01', 1, 2),
('B02', '2012-07-07', 'Y', 'K08', 'K03', 3, 2),
('D03', '2012-07-07', 'Y', 'K05', 'K09', 2, 1),
('D01', '2012-07-07', 'Y', 'K07', 'K10', 1, 0),
('B04', '2012-07-10', 'Y', 'K02', 'K01', 2, 1),
('D03', '2012-07-10', 'Y', 'K05', 'K03', 1, 1),
('D02', '2012-07-10', 'Y', 'K10', 'K04', 0, 2),
('C02', '2012-07-10', 'Y', 'K06', 'K08', 3, 1),
('D01', '2012-07-10', 'Y', 'K07', 'K09', 0, 0),
('C06', '2012-07-13', 'Y', 'K03', 'K06', 2, 1),
('B05', '2012-07-14', 'Y', 'K09', 'K02', 3, 0),
('B01', '2012-07-14', 'Y', 'K04', 'K07', 1, 0),
('D02', '2012-07-14', 'Y', 'K10', 'K08', 1, 1),
('D01', '2012-07-17', 'Y', 'K07', 'K01', 0, 0),
('C06', '2012-07-17', 'Y', 'K03', 'K02', 2, 0),
('B02', '2012-07-17', 'Y', 'K08', 'K04', 2, 1),
('C02', '2012-07-17', 'Y', 'K06', 'K05', 1, 2),
('B05', '2012-07-17', 'Y', 'K09', 'K10', 1, 1),
('D01', '2012-07-20', 'Y', 'K07', 'K03', 1, 1),
('B04', '2012-07-21', 'Y', 'K02', 'K06', 2, 2),
('D03', '2012-07-21', 'Y', 'K05', 'K08', 2, 2),
('B01', '2012-07-21', 'Y', 'K04', 'K09', 1, 3),
('D03', '2012-07-24', 'Y', 'K05', 'K02', 1, 1),
('D02', '2012-07-24', 'Y', 'K10', 'K03', 1, 1),
('C02', '2012-07-24', 'Y', 'K06', 'K07', 0, 1),
('B02', '2012-07-24', 'Y', 'K08', 'K09', 1, 1),
('C06', '2012-07-27', 'Y', 'K03', 'K04', 2, 1),
('D01', '2012-07-27', 'Y', 'K07', 'K05', 2, 1),
('C02', '2012-07-27', 'Y', 'K06', 'K10', 3, 0),
('B05', '2012-07-28', 'Y', 'K09', 'K01', 1, 1),
('B04', '2012-07-28', 'Y', 'K02', 'K08', 2, 2),
('B02', '2012-07-31', 'Y', 'K08', 'K01', 2, 0),
('B05', '2012-07-31', 'Y', 'K09', 'K03', 3, 1),
('D02', '2012-07-31', 'Y', 'K10', 'K05', 1, 0),
('B01', '2012-07-31', 'Y', 'K04', 'K06', 3, 2),
('B04', '2012-07-31', 'Y', 'K02', 'K07', 1, 2),
('B02', '2012-08-03', 'Y', 'K08', 'K07', 1, 0),
('C02', '2012-08-03', 'Y', 'K06', 'K09', 2, 1),
('D02', '2012-08-04', 'Y', 'K10', 'K02', 0, 3),
('C04', '2012-05-08', 'Y', 'K01', 'K08', 1, 3),
('C04', '2012-07-13', 'Y', 'K01', 'K05', 0, 0),
('C04', '2012-07-20', 'Y', 'K01', 'K10', 0, 0),
('C04', '2012-07-24', 'Y', 'K01', 'K04', 1, 1),
('C04', '2012-08-03', 'Y', 'K01', 'K03', 3, 0),
('C04', '2012-08-11', 'Y', 'K01', 'K06', 0, 0),
('C04', '2012-08-28', 'Y', 'K01', 'K07', 0, 1),
('C04', '2012-09-18', 'N', 'K01', 'K03', NULL, NULL),
('C04', '2012-10-19', 'N', 'K01', 'K08', NULL, NULL),
('C04', '2012-10-23', 'N', 'K01', 'K09', NULL, NULL),
('C04', '2012-11-02', 'N', 'K01', 'K10', NULL, NULL),
('C04', '2012-11-10', 'N', 'K01', 'K02', NULL, NULL),
('C04', '2012-11-17', 'N', 'K01', 'K06', NULL, NULL),
('C04', '2012-11-24', 'N', 'K01', 'K08', NULL, NULL),
('C06', '2012-03-17', 'Y', 'K03', 'K02', 1, 2),
('B02', '2012-03-17', 'Y', 'K08', 'K04', 6, 0),
('D02', '2012-03-17', 'Y', 'K10', 'K06', 2, 1),
('C05', '2012-03-17', 'Y', 'K11', 'K09', 2, 2),
('D01', '2012-03-20', 'Y', 'K07', 'K01', 1, 2),
('D03', '2012-03-20', 'Y', 'K05', 'K03', 1, 0),
('B04', '2012-03-20', 'Y', 'K02', 'K08', 2, 3),
('B05', '2012-03-20', 'Y', 'K09', 'K10', 2, 0),
('B04', '2012-03-23', 'Y', 'K02', 'K05', 2, 0),
('C02', '2012-03-24', 'Y', 'K06', 'K01', 1, 2),
('B01', '2012-03-24', 'Y', 'K04', 'K03', 1, 1),
('B05', '2012-03-24', 'Y', 'K09', 'K07', 1, 0),
('D01', '2012-03-27', 'Y', 'K07', 'K06', 2, 1),
('C06', '2012-03-27', 'Y', 'K03', 'K08', 1, 0),
('C05', '2012-03-27', 'Y', 'K11', 'K10', 0, 1),
('D03', '2012-04-06', 'Y', 'K05', 'K04', 3, 2),
('B01', '2012-04-10', 'Y', 'K04', 'K02', 2, 0),
('B02', '2012-04-10', 'Y', 'K08', 'K05', 2, 1),
('D02', '2012-04-10', 'Y', 'K10', 'K07', 1, 1),
('C02', '2012-04-10', 'Y', 'K06', 'K09', 1, 4),
('D02', '2012-04-14', 'Y', 'K10', 'K01', 0, 2),
('B02', '2012-04-14', 'Y', 'K08', 'K03', 1, 1),
('B01', '2012-04-14', 'Y', 'K04', 'K05', 1, 0),
('C02', '2012-04-14', 'Y', 'K06', 'K07', 2, 0),
('D03', '2012-04-20', 'Y', 'K05', 'K08', 2, 2),
('D01', '2012-04-20', 'Y', 'K07', 'K10', 0, 1),
('B04', '2012-04-21', 'Y', 'K02', 'K04', 3, 2),
('B05', '2012-04-21', 'Y', 'K09', 'K06', 1, 0),
('B02', '2012-04-24', 'Y', 'K08', 'K02', 1, 1),
('C06', '2012-04-24', 'Y', 'K03', 'K05', 1, 2),
('C05', '2012-04-24', 'Y', 'K11', 'K07', 1, 2),
('D02', '2012-04-24', 'Y', 'K10', 'K09', 1, 3),
('C06', '2012-04-27', 'Y', 'K03', 'K04', 0, 3),
('C05', '2012-04-27', 'Y', 'K11', 'K06', 5, 2),
('D01', '2012-04-27', 'Y', 'K07', 'K09', 0, 1),
('D03', '2012-04-28', 'Y', 'K05', 'K02', 1, 2),
('B05', '2012-05-01', 'Y', 'K09', 'K01', 0, 0),
('B04', '2012-05-01', 'Y', 'K02', 'K03', 1, 2),
('B01', '2012-05-01', 'Y', 'K04', 'K08', 2, 2),
('D03', '2012-09-04', 'Y', 'K05', 'K02', 1, 2),
('B02', '2012-09-04', 'Y', 'K08', 'K09', 1, 0),
('C05', '2012-09-04', 'Y', 'K11', 'K04', 2, 2),
('C06', '2012-09-04', 'Y', 'K03', 'K10', 0, 0),
('C02', '2012-09-04', 'Y', 'K06', 'K07', 2, 2);

 

 

실행 순서 5 - 2

 

INSERT INTO schedule (stadium_id, sche_date, gubun, hometeam_id, awayteam_id, home_score, away_score)
VALUES
('D03','2012-08-04','Y','K05','K04',2,1),
('B01','2012-08-11','Y','K04','K02',0,2),
('B05','2012-08-11','Y','K09','K05',0,1),
('C06','2012-08-11','Y','K03','K08',2,0),
('D01','2012-08-11','Y','K07','K10',1,1),
('D03','2012-08-18','Y','K05','K01',0,2),
('C02','2012-08-18','Y','K06','K03',3,1),
('B01','2012-08-18','Y','K04','K07',1,0),
('B04','2012-08-18','Y','K02','K09',1,2),
('B02','2012-08-18','Y','K08','K10',3,1),
('B04','2012-08-24','Y','K02','K01',1,1),
('D03','2012-08-24','Y','K05','K03',3,3),
('B02','2012-08-24','Y','K08','K06',4,3),
('D02','2012-08-25','Y','K10','K04',1,1),
('B05','2012-08-25','Y','K09','K07',1,1),
('C06','2012-08-28','Y','K03','K02',0,0),
('C02','2012-08-28','Y','K06','K05',1,1),
('B01','2012-08-28','Y','K04','K08',2,3),
('B05','2012-08-28','Y','K09','K10',2,0),
('D02','2012-09-01','Y','K10','K01',2,3),
('D01','2012-09-01','Y','K07','K03',0,1),
('B04','2012-09-01','Y','K02','K06',1,1),
('D03','2012-09-01','Y','K05','K08',3,3),
('B01','2012-09-01','Y','K04','K09',2,1);