https://programmers.co.kr/learn/courses/30/lessons/59410
์ฝ๋ฉํ ์คํธ ์ฐ์ต - NULL ์ฒ๋ฆฌํ๊ธฐ
ANIMAL_INS ํ ์ด๋ธ์ ๋๋ฌผ ๋ณดํธ์์ ๋ค์ด์จ ๋๋ฌผ์ ์ ๋ณด๋ฅผ ๋ด์ ํ ์ด๋ธ์ ๋๋ค. ANIMAL_INS ํ ์ด๋ธ ๊ตฌ์กฐ๋ ๋ค์๊ณผ ๊ฐ์ผ๋ฉฐ, ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE๋ ๊ฐ๊ฐ ๋๋ฌผ์ ์์ด๋
programmers.co.kr
SELECT ANIMAL_TYPE, IFNULL(NAME, "No name") as NAME, SEX_UPON_INTAKE
FROM ANIMAL_INS
ORDER BY ANIMAL_ID ASC
IFNULL(NAME, "No name") as NAME <- ๋ง์ฝ NULL์ธ ๊ฒฝ์ฐ์ No name ์ถ๋ ฅ ์๋๋ฉด NAME์ ๊ทธ๋๋ก ์ถ๋ ฅ
์ฐธ์กฐ:
MySQL ์ ์ด ํจ์ (CASE, IF, IFNULL, NULLIF)
1. CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [ELSE result] END CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END 2...
cyller.tistory.com
'๐๊ณต๋ถ > ์ฝ๋ฉํ ์คํธ' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
ํ๋ก๊ทธ๋๋จธ์ค - ํผ๋ณด๋์น ์, ํ์ด์ฌ & C++ (0) | 2021.11.22 |
---|---|
ํ๋ก๊ทธ๋๋จธ์ค - ์ต๋๊ฐ๊ณผ ์ต์๊ฐ, ํ์ด์ฌ (0) | 2021.11.22 |
ํ๋ก๊ทธ๋๋จธ์ค - ์ ํ๋ฒํธ ๋ชฉ๋ก, ํ์ด์ฌ & C++ (0) | 2021.11.21 |
ํ๋ก๊ทธ๋๋จธ์ค - ๋๋ฌผ ์ ๊ตฌํ๊ธฐ, MySQL (0) | 2021.11.21 |
ํ๋ก๊ทธ๋๋จธ์ค - x๋งํผ ๊ฐ๊ฒฉ์ด ์๋ n๊ฐ์ ์ซ์, C++ (0) | 2021.11.21 |