SQL(2)

INSERT

mysql> create table person #TABLE 만들기
    -> (
    ->          id int,
    ->          name varchar(16),
    ->          age int,
    ->          sex CHAR
    -> );

mysql> insert into person (id,name,age,sex)
    -> values(1,'이효리',43,'F'); # VALUES 넣어주기 

mysql> select * from person; # VALUES 모두 불러오기
select name,age,sex from person; # 특정 조건만 불러오기 
select * from person where sex='F'; # 특정 조건인 VALUES 불러오기 

mysql> update person set age=23 where name='이효리';# update하기

delete from person where name='이상순'; # 삭제하기 

ORDER BY

mysql> create table celeb
    -> (
    ->  ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    ->  NAME varchar(32) NOT NULL DEFAULT'',
    ->   BIRTHDAY date,
    -> AGE int,
    ->  SEX char(1),
    ->  JOB_TITLE varchar(32),
    ->  AGENCY varchar(32)
    -> );
    
    
INSERT INTO celeb VALUES (1, '아이유', '1993-05-16', 29, 'F', '가수,텔런트', 'EDAME엔터테이먼트);
INSERT INTO celeb VALUES (2, '이미주', '1994-09-23', 28, 'F', '가수', '울림엔터테이먼트'); 
INSERT INTO celeb VALUES (3, '송강', '1994-04-23', 28, 'M', '텔런트', '나무엑터스'); 
INSERT INTO celeb VALUES (4, '강동원', '1981-01-18', 41, 'M', '영화배우, 텔런트', 'YG엔터테이먼트);
INSERT INTO celeb VALUES (5, '유재석', '1972-08-14', 50, 'M', 'MC, 개그맨', '안테나'); 
INSERT INTO celeb VALUES (6, '차승원', '1970-06-07', 48, 'M', '영화배우, 모델', 'YG엔터테이먼트);
INSERT INTO celeb VALUES (7, '이수현', '1999-05-04', 23, 'F', '가수', 'Y');

mysql> select age,name
    -> from celab
    -> order by age DESC, name ASC; # 나이는 내림차순, 이름은 오름 차순 
    

COMPARISION OPERATORS

mysql> select name,age,job_title
    -> from celab
    -> where age>=29
    -> order by age DESC;