MySQL 클러스터, 리플리케이션, 서버튜닝

 

 

 

 

 


by 아이앤아이브레인 | 2010/11/05 18:33 | 트랙백 | 덧글(0)

SQLdic 샘플 디비 : soccerdb ver2.1 (league 테이블 데이타)

SQLdic 샘플 디비 : soccerdb ver2.1 (league 테이블 데이타)
MySQL 모든 것(http://www.inibrain.com)


INSERT INTO league
  (code, name, feature, countrycode)
VALUES
  ("PML", "프리미어리그", "프리미어리그는 잉글랜드의 리그이며 많은 축구 선수들의 꿈의 무대이다. 우리나라 선수들도 최근에 많은 활약을 보여주고 있는 곳이기도하다.", "ENG");

INSERT INTO league
  (code, name, feature, countrycode)
VALUES
  ("PMG", "프리메라리가", "프리메라리가 리그는 스페인의 리그이며 38라운드로 진행되고 승점으로 순위를 경정하는 방식이다.", "SPA");

INSERT INTO league
  (code, name, feature, countrycode)
VALUES
  ("SRE", "세리에 A", "세리에A 리그는 이탈리아의 리그이며 수비적 스타일로 공격은 3명만이 주도하는 매우 수비적인 축구를 구사하는 것이 특징이다.", "ITY");

INSERT INTO league
  (code, name, feature, countrycode)
VALUES
  ("BDG", "분데스리가", "분대스리가 리그는 독일의 리그이며 플레이는 미드필더의 플레이를 강조하는 것이 특징이다.", "GER");

INSERT INTO league
  (code, name, feature, countrycode)
VALUES
  ("RSO", "르샹피오나", "르샹피오나 리그는 프랑스의 리그이며 현대적인 플레이를 하며, 압박과 체력을 중요시하는 것이 특징이다. 특히 조직력이 좋다.", "FRA");

by 아이앤아이브레인 | 2010/11/05 18:31 | 트랙백 | 덧글(0)

SQLdic 샘플 디비 : soccerdb ver2.1 (player 테이블 데이타)

SQLdic 샘플 디비 : soccerdb ver2.1 (player 테이블 데이타)
MySQL 모든 것( http://www.inibrain.com )

 

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (1, "니콜라스 아넬카", 37, 19, "A03");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (2, "크리스티아누 호나우도", 33, 18, "A01");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (3, "스티븐 제라드", 31, 16, "A02");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (4, "페르난도 토레스", 24, 14, "A02");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (5, "데 수자 호빙요", 31, 14, "A10");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (6, "대런 벤트", 33, 12, "A08");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (7, "웨인 루니", 30, 12, "A01");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (8, "디르크 카윗", 38, 12, "A02");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (9, "프랭크 램퍼드", 37, 12, "A03");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (10, "로빈 판 페르시", 28, 11, "A04");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (11, "가브리엘 아그본라허", 36, 11, "A06");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (12, "리카르도 풀러", 34, 11, "A12");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (13, "저메인 디포", 27, 11, "A08");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (14, "케빈 데이비스", 38, 11, "A13");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (15, "욘 카레브", 27, 11, "A06");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (16, "매튜 테일러", 34, 10, "A13");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (17, "켄와인 존스", 29, 10, "A16");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (18, "칼튼 콜", 27, 10, "A09");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (19, "로비 킨", 33, 10, "A08");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (20, "지브릴 시세", 35, 10, "A16");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (21, "암르 자키", 29, 10, "A11");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (22, "에마뉘엘 아데바요르", 26, 10, "A04");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (23, "베네딕트 맥카시", 28, 10, "A15");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (24, "스티븐 아일랜드", 35, 9, "A10");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (25, "피터 크라우치", 38, 9, "A14");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (26, "크리스 브런트", 34, 9, "A20");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (27, "디미타르 베르바토프", 32, 9, "A01");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (28, "니클라스 벤트너", 31, 9, "A04");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (29, "데이베르손 지오반니", 34, 8, "A17");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (30, "팀 카힐", 30, 8, "A05");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (31, "디에고 포를란", 33, 32, "A24");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (32, "사무엘 에투", 36, 30, "A21");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (33, "다비드 비야", 33, 27, "A26");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (34, "리오넬 메시", 31, 23, "A21");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (35, "곤잘로 이구아인", 34, 22, "A22");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (36, "티에리 앙리", 29, 19, "A21");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (37, "프레데릭 카누테", 34, 18, "A23");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (38, "알바로 네그레도", 34, 18, "A31");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (39, "세르히오 아구에로", 37, 18, "A24");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (40, "곤잘레스 라울", 37, 18, "A22");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (41, "호세바 로렌테", 32, 15, "A25");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (42, "페르난도 요렌테", 34, 14, "A33");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (43, "니콜라 지기치", 19, 13, "A32");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (44, "로베르토 솔다도", 34, 13, "A37");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (45, "주세페 로시", 30, 12, "A25");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (46, "호세 바르케로", 37, 12, "A39");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (47, "마테 빌리치", 36, 12, "A34");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (48, "아킬레 에마나", 36, 12, "A38");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (49, "후안 마타", 37, 11, "A26");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (50, "아리츠 아두리츠", 35, 11, "A29");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (51, "월터 판디아니", 24, 11, "A36");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (52, "헤노크 고이톰", 29, 10, "A35");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (53, "하비에르 카무나스", 34, 10, "A40");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (54, "다비드 바랄", 35, 10, "A34");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (55, "호세 마누엘 후라도", 35, 9, "A29");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (56, "나빌 바하", 36, 9, "A28");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (57, "페레즈 아드리안 콜룽가", 34, 9, "A40");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (58, "데 라 푸엔테 세르히오 가르시아", 28, 9, "A38");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (59, "안토니오 아포노", 32, 9, "A28");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (60, "앙헬 라피타", 32, 8, "A27");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (61, "즐라탄 이브라히모비치", 35, 25, "A41");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (62, "알베르토 디에고 밀리토", 31, 24, "A45");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (63, "마르코 디 바이오", 38, 24, "A57");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (64, "알베르토 질라르디노", 35, 19, "A44");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (65, "히카르도 카카", 31, 15, "A43");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (66, "다 실바 알렌산드르 파투", 36, 15, "A43");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (67, "파브리치오 미콜리", 30, 14, "A48");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (68, "에딘손 카바니", 35, 14, "A48");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (69, "로베르트 아퀴아프레스카", 36, 14, "A49");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (70, "프란세스코 토티", 24, 13, "A46");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (71, "파비오 콸리아렐라", 35, 13, "A47");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (72, "세르지오 펠리시에르", 38, 13, "A56");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (73, "알레산드로 델피에로", 31, 13, "A42");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (74, "필리포 인자기", 27, 13, "A43");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (75, "마우로 자라테", 35, 13, "A50");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (76, "아드리안 무투", 19, 13, "A44");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (77, "안토니오 카사노", 36, 12, "A53");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (78, "카르발료 데 올리베이라 아마우리", 32, 12, "A42");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (79, "세르지오 플로카리", 32, 12, "A51");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (80, "빈첸초 이아퀸타", 28, 12, "A42");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (81, "쥐세페 마스카라", 34, 12, "A55");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (82, "안토니오 디 나탈레", 22, 12, "A47");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (83, "시모네 트리보치", 36, 11, "A60");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (84, "제다이아스 카푸초 네베스 제다", 36, 11, "A49");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (85, "잠파올로 파치니", 32, 11, "A53");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (86, "미르코 부치니치", 27, 11, "A46");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (87, "베르나르도 코라디", 30, 10, "A59");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (88, "게타노 디아고스티노", 35, 10, "A47");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (89, "크리스티아노 도니", 32, 9, "A51");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (90, "톰마소 로치", 27, 9, "A50");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (91, "리바노 바티스타 그라피트", 25, 28, "A61");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (92, "에딘 제코", 30, 26, "A61");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (93, "마리오 고메즈", 31, 23, "A63");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (94, "패트릭 헬메스", 34, 21, "A69");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (95, "베다드 이비세비치", 16, 18, "A67");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (96, "클라우디오 피사로", 26, 17, "A70");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (97, "밀리보예 노바코비치", 29, 15, "A72");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (98, "루카 토니", 25, 14, "A62");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (99, "뎀바 바", 32, 14, "A67");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (100, "케빈 쿠라니", 32, 13, "A68");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (101, "아르투르 비치니아레크", 31, 13, "A78");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (102, "스테판 키에슬링", 34, 12, "A69");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (103, "리바스 디에고", 21, 12, "A70");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (104, "알렉산더 프레이", 29, 12, "A66");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (105, "안드리 보로닌", 27, 11, "A64");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (106, "미로슬라프 클로제", 26, 10, "A62");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (107, "믈라덴 페트리치", 23, 10, "A65");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (108, "디미타르 랑겔로프", 26, 9, "A76");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (109, "미겔 우고 알메이다", 27, 9, "A70");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (110, "니코스 리베로폴로스", 29, 9, "A73");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (111, "프랑크 리베리", 25, 9, "A62");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (112, "제퍼슨 파르판", 29, 9, "A68");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (113, "이비차 올리치", 29, 9, "A65");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (114, "파올로 게레로", 29, 9, "A65");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (115, "세바스티안 프레이스", 34, 9, "A77");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (116, "세야드 살리호비치", 28, 8, "A67");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (117, "마르케스 카를로스 에두아르도", 25, 8, "A67");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (118, "스타니슬라브 세스타크", 22, 8, "A74");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (119, "사미 케디라", 26, 7, "A63");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (120, "산토스 시세로", 33, 7, "A64");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (121, "앙드레 피에르 지냑", 38, 23, "A82");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (122, "쥘라우메 호아루", 33, 17, "A84");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (123, "카림 벤제마", 36, 17, "A81");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (124, "이레네우시 옐렌", 26, 14, "A86");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (125, "페르난데스 미첼 바스토스", 37, 14, "A83");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (126, "스티브 사비당", 38, 13, "A96");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (127, "마마두 니앙", 27, 12, "A80");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (128, "마루안 차마크", 32, 12, "A79");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (129, "메블루트 에르딩", 36, 11, "A92");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (130, "케빈 가메이로", 36, 11, "A88");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (131, "페르난도 카베나기", 28, 10, "A79");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (132, "바카리 콘", 28, 10, "A80");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (133, "모우사 소우", 30, 10, "A85");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (134, "요안 구르쿠프", 36, 10, "A79");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (135, "바페텡베 고미", 36, 10, "A95");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (136, "로이치 레미", 32, 10, "A87");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (137, "아라우조 일랑", 31, 9, "A95");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (138, "아마두 알라산", 31, 9, "A98");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (139, "유스프 하지", 36, 9, "A93");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (140, "토르스텐 헬스타드", 31, 9, "A94");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (141, "바클라프 스베르코스", 19, 8, "A92");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (142, "페르남부카노 주닝요", 29, 7, "A81");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (143, "조앙 오델", 28, 7, "A90");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (144, "루도비치 지울리", 34, 7, "A84");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (145, "에바에예르슨 브란다오", 16, 7, "A80");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (146, "모디보 마이가", 37, 7, "A94");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (147, "마마두 바가요코", 25, 7, "A97");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (148, "파브리스 아브리엘", 35, 7, "A88");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (149, "나심 아쿠어", 36, 7, "A91");

INSERT INTO player
  (idx, name, game, score, teamcode)
VALUES
  (150, "루도비치 오브라니악", 33, 7, "A83");

by 아이앤아이브레인 | 2010/11/05 18:31 | 트랙백 | 덧글(0)

SQLdic 샘플 디비 : soccerdb ver2.1 (team 테이블 데이타)

SQLdic 샘플 디비 : soccerdb ver2.1 (team 테이블 데이타)
MySQL의 모든 것(http://www.inibrian.com)


INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A01", "맨체스터 유나이티드 FC", "랭커셔주 맨체스터", "올드 트랜포드", 1878, 38, 28, 6, 4, 68, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A02", "리버풀 FC", "머지사이드주 리버풀", "앤필드 로드", 1892, 38, 25, 11, 2, 77, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A03", "첼시 FC", "런던", "스탬포드 브릿지", 1905, 38, 25, 8, 5, 68, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A04", "아스날 FC", "런던", "에미레이츠 스타디움", 1886, 38, 20, 12, 6, 68, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A05", "에버튼 FC", "머지사이드 리버풀", "구디슨 파크", 1878, 38, 17, 12, 9, 55, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A06", "아스톤 빌라 FC", "버밍엄", "빌라 파크", 1874, 38, 17, 11, 10, 54, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A07", "풀럼 FC", "런던", "클라벤 코티지", 1879, 38, 14, 11, 13, 39, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A08", "토트넘 핫스퍼 FC", "런던", "화이트 하트 레인", 1882, 38, 14, 9, 15, 45, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A09", "웨스트햄 유나이티드 FC", "웨스트햄", "불린 그라운드", 1900, 38, 14, 9, 15, 42, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A10", "맨체스터 시티 FC", "랭커셔주 맨체스터", "시티 오브 맨체스터", 1880, 38, 15, 5, 18, 58, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A11", "위건 애슬레틱 FC", "위건", "JJB 스타디움", 1932, 38, 12, 9, 17, 34, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A12", "스토크 시티 FC", "웨스트미들랜드주 스테포드셔 스토크 온 트렌트", "프라탄니아 스타디움", 1863, 38, 12, 9, 17, 38, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A13", "볼튼 원더러스 FC", "그레이터맨체스터주 볼트", "리복 스타디움", 1874, 38, 11, 8, 19, 41, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A14", "포츠머스 FC", "햄프셔주 포츠머스", "프라톤 파크", 1898, 38, 10, 11, 17, 38, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A15", "블랙번 FC", "랭커셔주 블랙번", "이우드 파크", 1875, 38, 10, 11, 17, 40, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A16", "선덜랜드 AFC", "타인위어주 선덜랜드", "스타디움 오브 라이트", 1879, 38, 9, 9, 20, 34, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A17", "헐 시티 AFC", "요크셔주 킹스턴 어폰 헐", "KC 스타디움", 1904, 38, 8, 11, 19, 39, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A18", "뉴캐슬 유나이티드 FC", "타인위어주 뉴캐슬어폰타인", "세인트 제임스 파크", 1881, 38, 7, 13, 18, 40, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A19", "미들즈브러 FC", "클리브랜드주 미들즈브러", "리버사이드 스타디움", 1876, 38, 7, 11, 20, 28, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A20", "웨스트 브롬위치 알비온 FC", "웨스트 브롬위치", "허손스", 1878, 38, 8, 8, 22, 36, "PML");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A21", "FC 바르셀로나", "바로셀로나", "누 캄푸", 1899, 38, 27, 6, 5, 105, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A22", "레알 마드리드", "마드리드", "산티아고 베르나베우", 1902, 38, 25, 3, 10, 83, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A23", "FC 세비야", "세비아", "라몬 산체스 피스후안 스타디움", 1898, 38, 21, 7, 10, 54, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A24", "아틀레티코 마드리드", "마드리드", "비센테 칼데론", 1903, 38, 20, 7, 11, 80, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A25", "비야르 레알 CF", "에스파냐 카스티야이레온주 비야르레알", "엘마드리갈", 1923, 38, 18, 11, 9, 61, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A26", "발렌시아 CF", "발렌시아", "메스타야", 1919, 38, 18, 8, 12, 68, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A27", "데포르티보 라 코루냐", "라 코루냐주", "리아조르", 1907, 38, 16, 10, 12, 48, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A28", "말라가", "말라가", "라로살레다", 1921, 38, 15, 10, 13, 55, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A29", "레알 마요르카", "발레아레스주 마요르카 섬", "손 모이스 스타디움", 1900, 38, 14, 9, 15, 53, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A30", "RCD 에스파뇰", "바로셀로나", "에스타디 올림픽 루이스 컴퍼니", 1900, 38, 12, 11, 15, 46, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A31", "UD 알메리아", "안달루시아 알메리아", "에스타디오 델 메디텔라니오", 1989, 38, 13, 7, 18, 45, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A32", "라싱 산탄데르", "칸타브리아 산탄데르", "엘 사르디네로", 1913, 38, 12, 10, 16, 49, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A33", "아틀레틱 빌바오", "비스카야주 빌바오", "산 마메스", 1898, 38, 12, 8, 18, 47, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A34", "스포르팅 히혼", "아스투리아스 히혼", "엘 몰리논", 1905, 38, 14, 1, 23, 47, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A35", "레알 바야돌리드", "카스티야레온 바야돌리드", "에스타디오 호세 소르리야", 1928, 38, 12, 7, 19, 46, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A36", "오사수나", "나바라 팜플로나에", "엘 사다르", 1920, 38, 10, 13, 15, 41, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A37", "헤타페", "마드리드 헤타페", "콜리세움 알폰소 페레즈", 1983, 38, 10, 12, 16, 50, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A38", "레알 베티스", "세비야주 세비야", "마누엘 루이스 데 로페라", 1907, 38, 10, 12, 16, 51, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A39", "누만시아", "카스티야레온 소리아", "로스 파야리토스", 1945, 38, 10, 5, 23, 38, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A40", "레크레아티보 우엘바", "안달루시아 우엘바", "콜롬비노", 1889, 38, 8, 9, 21, 34, "PMG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A41", "인터 밀란", "롬바르디아 밀라노", "산 시로", 1908, 38, 25, 9, 4, 70, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A42", "유벤투스 FC", "피에몬테주 토리노", "델레 알피", 1897, 38, 21, 11, 6, 69, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A43", "AC 밀란", "롬바르디아 밀라노", "산 시로", 1899, 38, 22, 8, 8, 70, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A44", "AC 피오렌티나", "토스카나주 피렌체", "아르테미오 프란키", 1899, 38, 21, 5, 12, 53, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A45", "제노아 FC", "제노바 루이지 페라리스", "루이지 페라리스 스타디움", 1893, 38, 19, 11, 8, 56, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A46", "AS 로마", "로마", "스타디오 올림피코", 1927, 38, 18, 9, 11, 64, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A47", "우디네세 칼초", "프리울리베네치아줄리아 우디네", "프리울리 스타디움", 1906, 38, 16, 10, 12, 61, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A48", "팔레르모", "감독루이지 델 네리", "렌조 바르베라", 1900, 38, 17, 6, 15, 57, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A49", "칼리아리 칼치오", "칼리아리", "코뮤날레 산텔리아", 1920, 38, 15, 8, 15, 49, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A50", "SS 라치오", "로마", "올림피코", 1900, 38, 15, 5, 18, 46, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A51", "아탈란타 BC", "롬바르디아 베르가모", "아틀레티 아주리 디 이탈리아", 1907, 38, 13, 8, 17, 45, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A52", "SSC 나폴리", "캄파니아주 나폴리", "스타디오 산 파올로", 1926, 38, 12, 10, 16, 43, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A53", "삼프도리아", "리구리아 제노바", "루이지 페라리스", 1946, 38, 11, 13, 14, 49, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A54", "시에나", "토스카나 시에나", "아르테미오 프란키", 1904, 38, 12, 8, 18, 33, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A55", "카타니아", "시칠리아 카타니아", "안젤로 마시미노", 1908, 38, 12, 7, 19, 41, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A56", "키에보", "토스카나 피렌체", "마르크 안토니오 벤테고디", 1929, 38, 8, 14, 16, 35, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A57", "볼로냐", "에밀리아로마냐 볼로냐", "스타디오 레나토 달라라", 1909, 38, 9, 10, 19, 43, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A58", "토리노 FC", "피에드몬테세주 토리노 ", "올림피코 디 토리노", 1906, 38, 8, 10, 20, 37, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A59", "레지나 칼초", "칼라브리아 레지오 칼라브리아", "스타디오 오르네스테 그라닐로", 1914, 38, 6, 13, 19, 30, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A60", "레체", "레체", "스타디오 비아 델 마레", 1908, 38, 5, 15, 18, 37, "SRE");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A61", "VfL 볼프스부르크", "니더작센 볼프스부르크", "폭스바겐 아레나", 1945, 34, 21, 6, 7, 80, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A62", "바이에른 뮌헨", "뮌헨", "알리안츠 아레나", 1900, 34, 20, 7, 7, 71, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A63", "VfB 슈투트가르트", "바덴뷔르템베르크주 슈투트가르트", "고트리브 다이믈러 스타디온", 1893, 34, 19, 7, 8, 63, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A64", "헤르타 베를린", "베를린", "올림피아스타디온", 1892, 34, 19, 6, 9, 48, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A65", "함부르크 SV", "함부르크", "AOL 아레나", 1887, 34, 19, 4, 11, 49, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A66", "보루시아 도르트문트", "노르트라인베스트팔렌주 도르트문트", "시크날 이두나 파크", 1909, 34, 15, 14, 5, 60, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A67", "TSG 1899 호펜하임", "바덴뷔르템베르크주 진하임", "카를 벤츠 슈타디온", 1899, 34, 15, 10, 9, 63, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A68", "샬케 04", "노르트라인베스트팔렌주 겔젠키르헨", "벨틴스 아레나", 1904, 34, 14, 8, 12, 47, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A69", "바이엘 레버쿠젠", "노르트라인베스트팔렌주 레버쿠젠", "바이 아레나", 1904, 34, 14, 7, 13, 59, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A70", "베르더 브레멘", "브레멘주 브레멘", "베저스타디온", 1899, 34, 12, 9, 13, 64, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A71", "하노버 96", "니더작센주 하노버", "AWD 아레나", 1896, 34, 10, 10, 14, 49, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A72", "쾰른", "노르트라인베스트팔렌주 쾰른", "뮌게르스도르퍼스타디온", 1948, 34, 11, 6, 17, 35, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A73", "아인트라흐트 프랑크푸르트", "바이에른주 뮌헨", "커머즈뱅크 아레나", 1899, 34, 8, 9, 17, 39, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A74", "VfL 보쿰", "노르트라인베스트팔렌주 보쿰", "루어 슈타디온", 1911, 34, 7, 11, 16, 39, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A75", "보루시아 묀헨글라드바흐", "헨글라드바흐", "보루시아파크", 1900, 34, 8, 7, 19, 39, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A76", "에네르기 코트부스", "브란덴부르크주 코트부스", "프레운드샤프트 스타디온", 1966, 34, 8, 6, 20, 30, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A77", "칼스루허", "칼스루허", "빌트파크 스타디온", 1894, 34, 8, 5, 21, 30, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A78", "아르마니아 빌레펠트", "노르트라인베스트팔렌주 빌레펠트", "쉬코 아레나", 1905, 34, 4, 16, 14, 29, "BDG");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A79", "보르도", "보르도", "스타드 샤방 델마", 1881, 38, 24, 8, 6, 64, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A80", "마르세유", "마르세유", "스타드 벨로드롬", 1899, 38, 22, 11, 5, 67, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A81", "올림피크 리옹", "론주 리옹", "제를랑 스타디움", 1950, 38, 20, 11, 7, 52, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A82", "툴루즈", "툴루즈", "스타디엄 데 툴루즈", 1937, 38, 16, 16, 6, 45, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A83", "릴", "노르파드칼레 노르주 릴", "릴 메트로폴", 1944, 38, 17, 13, 8, 51, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A84", "파리 생제르망", "파리", "프린세스 파크", 1970, 38, 19, 7, 12, 49, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A85", "렌", "브르타뉴 일레빌렌주 렌", "루트 드 로리앙", 1901, 38, 15, 16, 7, 42, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A86", "옥세르", "옥세르", "스타드 데 아이 아베 데샹", 1905, 38, 16, 7, 15, 35, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A87", "니스", "니스", "스타드 뒤 레이", 1904, 38, 13, 11, 14, 40, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A88", "로리앙", "로리앙", "루트 드 로리앙", 1926, 38, 10, 15, 13, 47, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A89", "모나코", "모나코", "루이스 2 스타디움", 1919, 38, 11, 12, 15, 41, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A90", "발랑시엔", "발랑시엔", "난제세르", 1915, 38, 10, 14, 14, 35, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A91", "그르노블", "이제르주 그르노블", "스타데 알프스", 1997, 38, 10, 14, 14, 24, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A92", "소쇼", "프랑슈콩테 두주 몽벨리아르", "스타드 어거스테 보날", 1928, 38, 10, 12, 16, 40, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A93", "낭시", "로렌 뫼르트에모젤주 낭시", "스타드 마르셀 피코", 1920, 38, 10, 12, 16, 38, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A94", "르망", "페이드라루아르 사르트주 르망", "스타드 레옹 볼레", 1985, 38, 10, 10, 18, 43, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A95", "셍테티엔", "셍테티엔", "스타드 조프루아 기샤드", 1920, 38, 11, 7, 20, 40, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A96", "캉", "칼바도스주 캉", "스타드 미쉘 도르나노", 1913, 38, 8, 13, 17, 42, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A97", "낭트", "낭트", "스타데 드 라 보주아르", 1943, 38, 9, 10, 19, 33, "RSO");

INSERT INTO team
  (code, name, connections, stadium, created, game, win, draw, lose, goal, leaguecode)
VALUES
  ("A98", "르하브르", "르 아브르", "르 아브르", 1872, 38, 7, 5, 26, 30, "RSO");

by 아이앤아이브레인 | 2010/11/05 18:30 | 트랙백 | 덧글(0)

SQLdic soccerdb_ver2.1 테이블(player, team, league, country) 컬럼 설명

SQLdic soccerdb_ver2.1 테이블(player, team, league, country) 컬럼 설명
MySQL의 모든 것( http://www.inibrain.com )


테이블(player) 상세 설명
*************************** 1. row ***************************
     idx: 번호
    name: 선수이름
    game: 출전 경기수
   score: 골 득점 수
teamcode: 소속 팀 코드


테이블(team) 상세 설명
*************************** 1. row ***************************
       code: 팀 코드
       name: 팀 이름
connections: 연고지
    stadium: 홈 경기장
    created: 창단연도
       game: 총 경기수
        win: 승
       draw: 무
       lose: 패
       goal: 골 득점
 leaguecode: 소속 리그 코드


테이블(league) 상세 설명
*************************** 1. row ***************************
       code: 리그 코드
       name: 리그 이름
    feature: 리그 특징
countrycode: 해당 국가 코드
1 row in set (0.02 sec)

테이블(country) 상세 설명
*************************** 1. row ***************************
      code: 국가 코드
      name: 국가 이름
  language: 사용하는 언어
population: 인구 수
       GNI: 국민 총 소득
       GNP: 국민 총 생산

by 아이앤아이브레인 | 2010/11/05 18:28 | 트랙백 | 덧글(0)

◀ 이전 페이지          다음 페이지 ▶