G4 World☆

 SELECT PLAYER_ID, PLAYER_NAME, TEAM_ID, POSITION, HEIGHT, WEIGHT, BACK_NO

 FROM PLAYER;

 SELECT ALL POSITION

 FROM PLAYER;

 ALL은 생략 가능한 키워드이므로 아래 SQL 문장도 같은 결과를 출력한다.

 SELECT POSITION

 FROM PLAYER;

 SELECT DISTINCT POSITION

 FROM PLAYER;

 SELECT *

 FROM PLAYER;

 SELECT PLAYER_NAME AS 선수명, POSITION AS 위치, HEIGHT AS 키, WEIGHT AS 몸무게
 FROM PLAYER;

 칼럼 별명에서 AS를 꼭 사용하지 않아도 되므로,

 아래 SQL은 위 SQL과 같은 결과를 출력한다.

 SELECT PLAYER_NAME 선수명, POSITION 위치, HEIGHT 키, WEIGHT 몸무게
 FROM PLAYER;

 SELECT PLAYER_NAME "선수 이름", POSITION "그라운드 포지션", HEIGHT "키", WEIGHT "몸무게"

 FROM PLAYER;

 DELETE FROM PLAYER; 

 SELECT * FROM PLAYER;

 UPDATE PLAYER

 SET BACK_NO = 99;

 SELECT * FROM PLAYER;

 UPDATE PLAYER

 SET POSITION = 'DF';

 SELECT * FROM PLAYER;

  create table player

 (

player_id char(7) not null,
player_name varchar(20) not null,
team_id char(3) not null,
e_player_name varchar(40),
nickname varchar(30),
join_yyyy char(4),
position varchar(10),
back_no tinyint,
nation varchar(20),
birth_date date,
solar char(1),
height smallint,

weight smallint,
constraint player_id_pk primary key(player_id)

 );

 INSERT INTO PLAYER (PLAYER_ID, PLAYER_NAME, TEAM_ID, POSITION, HEIGHT, WEIGHT, BACK_NO)

 VALUES ('2002007', '박지성', 'K07', 'MF', 178, 73, 7);

 SELECT * FROM PLAYER;

 INSERT INTO PLAYER VALUES

 ('2002010','이청용','K07','','BlueDragon','2002','MF','17',NULL, NULL,'1',180,69);  

 SELECT * FROM PLAYER;