내일은 SQL(응용 실전편) 실전_ch1-2-1-member_info.sql

[교재 SQL 스크립트] 실전_ch1-2-1-member_info.sql

use mydb;

CREATE TABLE member_info (
    member_no INT,
    name VARCHAR(10),
    gender VARCHAR(1)
);

INSERT INTO member_info
VALUES (10, '이장현', 'M');
INSERT INTO member_info
VALUES (20, '유길채', 'F');
INSERT INTO member_info
VALUES (30, '남연준', 'M');
INSERT INTO member_info
VALUES (40, '경은애', 'F');
INSERT INTO member_info
VALUES (50, '량음', 'M');

COMMIT;

SELECT name,
       CASE member_info.gender
        WHEN 'F' THEN '여자'
        WHEN 'M' THEN '남자'
        END AS gender
  FROM member_info;

SELECT name,
       IF(gender = 'F', '여자', '남자') AS gender
  FROM member_info;