Quiz3. Insert, Update, Delete

[kyohoonsim]

3-1. [SQL 쿼리] [실행화면 캡쳐]

3-2. [SQL 쿼리] [실행화면 캡쳐]

3-3. [SQL 쿼리] [실행화면 캡쳐]

[xinnazim]

QUIZ 3

3-1.

INSERT INTO player(seq,name,age,company,country) VALUES (6,'김정은',22,'맨유','한국');

INSERT INTO player(seq,name,age,company,country) VALUES (7,'전이빈',23,'토트넘','한국');

INSERT INTO player(seq,name,age,company,country) VALUES (8,'백동석',25,'맨유','한국');

3-2.

INSERT INTO player(seq,name,age,company,country) VALUES (9,'유지민',23,'토트넘','한국');

SELECT * FROM player;

3-3.

DELETE FROM player WHERE seq=9;

SELECT * FROM player;

[dhEhdod]

3-1. INSERT INTO player (seq, name, age, company, country) VALUES (6, '김예지', 22, '4조', '한국');

INSERT INTO player (seq, name, age, company, country) VALUES (7, '박종일', 25, '4조', '한국');

INSERT INTO player (seq, name, age, company, country) VALUES (8, '우인지', 25, '4조', '한국');

INSERT INTO player (seq, name, age, company, country) VALUES (9, '유정우', 25, '4조', '한국');

3-2. UPDATE player SET country = '미국' WHERE seq = 6;

3-3. DELETE FROM player WHERE seq = 6;

[echoe1009]

3-1. INSERT INTO player(seq, name, age, company, country) VALUES(6, '최은섭', 23, 'A', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES(7, '신지민', 23, 'B', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES(8, '김용환', 23, 'C', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES(9, '우지호', 23, 'D', '한국');

3-2. UPDATE player SET country = '북한' WHERE seq = 6;

3-3. DELETE FROM player WHERE seq = 6;

[KUSFTWOO]

INSERT INTO player(seq, name, age, company, country) VALUES (6, '고현림',24, '바르셀로나', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (7, '김태우',24, '맨시티', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (8, '정원영',22, '토트넘', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (9, '이지혜',21, '맨유', '한국'); UPDATE player SET company = '바르셀로나' WHERE seq = 7; DELETE FROM player WHERE seq = 7;

[hungrywoo]

3-1. INSERT INTO player(seq, name, age, company, country) VALUES (6, '김예지', 22, '4조', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (7, '박종일', 25, '4조', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (8, '유정우', 25, '4조', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (9, '우인지', 25, '4조', '한국');

3-2. UPDATE player SET company = '토트넘' WHERE seq = 9;

3-3. DELETE FROM player WHERE seq = 9;

[monimanimo]

3-1 insert into player (seq, name, age, company, country) values (6, '성준모', 22, '첼시', '한국');

insert into player (seq, name, age, company, country) values (7, '이준수', 25, '맨시티', '한국');

insert into player (seq, name, age, company, country) values (8, '이규현', 24, '리버풀', '한국');

insert into player (seq, name, age, company, country) values (9, '유예린', 21, '뉴캐슬', '한국');

3-2 update player set company = '아스날' where seq =6;

3-3 delete from player where company = '아스날';

[last0331]

3-1. INSERT INTO player(seq, name, age, company, country) VALUES (6, '우인지', 25, '두산', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (7, '김예지', 22, '엘지', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (8, '박종일', 25, '두산', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (9, '유정우', 25, '두산', '한국');

3-2. UPDATE player SET country = '프랑스' WHERE seq = 9;

3-3 .DELETE FROM player WHERE seq = 9;

[YelynYoo]

3-1. insert into player(seq, name, age, company, country) values(6, '이준수', 25, '맨유', '한국');

insert into player(seq, name, age, company, country) values(7, '성준모', 22, '토트넘', '한국');

insert into player(seq, name, age, company, country) values(8, '이규헌', '24', '바르셀로나', '한국');

insert into player(seq, name, age, company, country) values(9, '유예린', '21',null, '한국');

3-2. update player set company = '토트넘' where seq = 9; select * from player where name = '유예린';

3-3. delete from player where seq = 9; select * from player;

[expediore]

3-1. insert into player(seq, name, age, company, country) values (6, '이준수', 25, '안암FC', '한국');

insert into player(seq, name, age, company, country) values (7, '이규헌', 24, '신림FC', '한국');

insert into player(seq, name, age, company, country) values (8, '성준모', 22, '인천FC', '한국');

insert into player(seq, name, age, company, country) values (9, '유예린', 21, '용인FC', '한국');

3-2. update player set age = 20 where seq = 6;

3-3. delete from player where seq = 6;

[jjjjjjye]

3-1 INSERT INTO player(seq, name, age, company, country) VALUES (6, '고현림', 24, 'KUSF', '한국'); INSERT INTO player(seq, name, age, company, country) VALUES (7, '김태우', 24, 'KUSF', '한국'); INSERT INTO player(seq, name, age, company, country) VALUES (8, '정원영', 22, 'KUSF', '한국'); INSERT INTO player(seq, name, age, company, country) VALUES (9, '이지혜', 21, 'KUSF', '한국');

SELECT * FROM player;

3-2 UPDATE player SET company = 'SKKU' WHERE seq = 9;

SELECT * FROM player;

3-3 DELETE FROM player WHERE seq = 9;

SELECT * FROM player;

[jeong1217]

3-1. [SQL 쿼리] [실행화면 캡쳐]

3-2. [SQL 쿼리] [실행 화면 캡쳐]

3-3. [SQL 쿼리] [실행화면 캡쳐]

[WooJHo]

3-1. insert INTO player(seq, name, age, company, country) values(6, '김용환', 24, '맨유', '한국'); insert INTO player(seq, name, age, company, country) values(7, '신지민', 21, '바르셀로나', '미국'); insert INTO player(seq, name, age, company, country) values(8, '최은섭', 23, '토트넘', '포르투갈'); insert INTO player(seq, name, age, company, country) values(9, '우지호', 25, '바르셀로나', '한국');

3-2. UPDATE player SET country='영국' WHERE seq=9;

3-3. DELETE FROM player WHERE seq=9;

[indianaPoly]

3-1. INSERT into player(seq, name, age, company, country) values (6, '현림', 24, 'KUSF', '한국'); INSERT into player(seq, name, age, company, country) values (7, '태우', 24, 'KUSF', '한국'); INSERT into player(seq, name, age, company, country) values (8, '원영', 21, 'KUSF', '한국'); INSERT into player(seq, name, age, company, country) values (9, '지혜', 21, 'KUSF', '한국');

3-2. update player set name = '고현림' where seq = 6;

3-3. delete from player where name = '고현림';

[Y0nghwan]

3-1

INSERT INTO player(seq, name, age, company, country) VALUES (6, '우지호', 20, 'A', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (7, '신지민', 21, 'B', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (8, '최은섭', 22, 'C', '한국');

INSERT INTO player(seq, name, age, company, country) VALUES (9, '김용환', 23, 'D', '한국');

데이터 확인

SELECT * FROM player;

3-2

김용환의 seq 확인

SELECT * FROM player;

김용환의 국적 한국 -> 미국으로 변경

UPDATE player SET country = '미국' WHERE seq = 9;

UPDATE 확인

SELECT * FROM player WHERE seq = 9;

3-3

DELETE FROM player WHERE seq = 9;

DELETE 확인

SELECT * FROM player;

[BAEKDONGSEOK]

3-1

3-2

3-3

[SHINZIMIN]

3-1

INSERT INTO player (seq, name, age, company, country) VALUES (6, '김용환', 23, '맨유', '한국');

INSERT INTO player (seq, name, age, company, country) VALUES (7, '우지호', 23, '토트넘', '한국');

INSERT INTO player (seq, name, age, company, country) VALUES (8, '최은섭', 23, '바르셀로나', '한국');

INSERT INTO player (seq, name, age, company, country) VALUES (9, '신지민', 23, '토트넘', '한국');

SELECT * FROM player;

3-2

UPDATE player SET country = '미국' WHERE seq = 9; SELECT * FROM player WHERE seq = 9;

3-3

DELETE FROM player WHERE seq = 9; SELECT * FROM player;

[yibeeeen]

3-1 INSERT INTO player (seq, name, age, company, country) values (6, '유지민', 23, '맨유', '한국');

INSERT INTO player (seq, name, age, company, country) values (7, '백동석', 25, '맨유', '한국');

INSERT INTO player (seq, name, age, company, country) values (8, '김정은', 22, '맨유', '한국');

INSERT INTO player (seq, name, age, company, country) values (9, '전이빈', 23, '맨유', '한국');

3-2 UPDATE player set company = '첼시' where seq = 9;

3-3 DELETE from player WHERE seq = 9;

[aosdbfc]

[2gyuheon]

3-1 INSERT INTO player (seq, name, age, company, country) values (6, '이준수', 25, '두산', '한국');

INSERT INTO player (seq, name, age, company, country) values (7, '성준모', 22, '한화', '한국');

INSERT INTO player (seq, name, age, company, country) values (8, '유예린', 21, '삼성', '한국');

INSERT INTO player (seq, name, age, company, country) values (9, '이규헌', 23, 'LG', '한국'); UPDATE player SET company = 'ssg' WHERE seq = 9 DELETE from player where seq = 9

[JJungEunnn]

3-1

3-2

3-3