SQL 연습3

수랜드·2020년 11월 24일
0
post-thumbnail

테이블에 값 넣기2 - 선수테이블

팀 마다 소속 되어있는 선수를 모두 넣기가 너무 힘들어서...
한 명씩만 넣어 봤습니다.

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'브루노 페르난데스','1994-09-08','포르투갈',179,69,6,3,1);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'손흥민','1992-07-08','대한민국',183,77,9,2,2);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'모하메드 살라','1992-06-15','이집트',175,71,8,0,3);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'티모 베르너','1996-03-06','독일',180,75,4,2,4);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'라카제트','1991-05-28','프랑스',175,73,3,0,5);


INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'카림 벤제마','1987-12-19','프랑스',185,81,4,3,6);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'리오넬 메시','1987-06-24','아르헨티나',170,72,3,0,7);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'카를로스 솔레르','1997-01-02','스페인',179,69,4,2,8);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'루이스 수아레스','1987-01-24','우루과이',182,83,5,1,9);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'유세프 엔 네시리','1997-06-01','모로코',188,73,3,0,10);


INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'로베르트 레반도프스키','1988-08-21','폴란드',185,79,11,4,11);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'엘링 홀란드','2000-07-21','노르웨이',194,88,10,2,12);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'루카스 알라리오','1992-10-08','아르헨티나',188,82,7,0,13);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'유수프 포울센','1994-06-15','덴마크',193,87,3,1,14);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'보우트 베흐호스트','1992-08-07','네덜란드',197,84,4,1,15);


INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'크리스티아누 호날두','1985-02-05','포르투갈',187,83,8,0,16);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'즐라탄 이브라히모비치','1981-10-03','스웨덴',195,95,10,8,17);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'헨리크 미키타리안','1989-01-21','아르메니아',177,75,5,4,18);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'로멜루 루카쿠','1993-05-13','벨기에',191,93,7,2,19);

INSERT INTO PLAYERS(player_id,name,birth_date,nation,height,weight,goals,assist,club_id)
VALUES(players_seq.nextval,'이르빙 로자노','1995-07-30','멕시코',178,67,4,1,20);

선수를 더 추가해야되는데...

profile
신입 개발자 입니다...

0개의 댓글