Search

NULL ๊ด€๋ จ ํ•จ์ˆ˜

NULL ๊ด€๋ จ ํ•จ์ˆ˜

ํ•จ์ˆ˜
์„ค๋ช…
IFNULL(ํ‘œํ˜„์‹1, ํ‘œํ˜„์‹2)
ํ‘œํ˜„์‹1์ด NULL์ด๋ฉด ํ‘œํ˜„์‹2๋ฅผ ๋ฐ˜ํ™˜
NULLIF(ํ‘œํ˜„์‹1, ํ‘œํ˜„์‹2)
๋‘ ํ‘œํ˜„์‹์ด ๊ฐ™์œผ๋ฉด NULL ๋ฐ˜ํ™˜, ๋‹ค๋ฅด๋ฉด ํ‘œํ˜„์‹1 ๋ฐ˜ํ™˜
COALESCE(๊ฐ’1, ๊ฐ’2, ..., ๊ฐ’n)
NULL์ด ์•„๋‹Œ ์ฒซ ๋ฒˆ์งธ ๊ฐ’์„ ๋ฐ˜ํ™˜