SQL - MySQL, UNION
ยท
๐Ÿงฉ SQL
โœ… Union์ด๋ž€?์—ฌ๋Ÿฌ ํ…Œ์ด๋ธ”์„ ํ•˜๋‚˜๋กœ ํ•ฉ์น˜๋Š” ๋ฐฉ๋ฒ•Union๊ณผ Join์˜ ์ฐจ์ด์ Join์œผ๋กœ ํ…Œ์ด๋ธ”์„ ํ•ฉ์น˜๋ฉด ๋” ๋งŽ์€ column์„ ๊ฐ–๊ฒŒ ๋œ๋‹ค. (์ˆ˜ํ‰์ ์œผ๋กœ ํ…Œ์ด๋ธ” ํ™•์žฅ)Union์€ ํ…Œ์ด๋ธ”์„ ์ˆ˜์ง์ ์œผ๋กœ ํ™•์žฅํ•œ๋‹ค. ์กฐ๊ฑด: ํ•ฉ์น˜๋Š” ํ…Œ์ด๋ธ”์€ ์„œ๋กœ ๊ฐ™์€ ์ˆ˜์˜ column์„ ๊ฐ€์ง€๊ณ  ์žˆ์–ด์•ผ ํ•œ๋‹ค.(๊ทธ๋ฆฌ๊ณ  ์ค‘๋ณต๋œ ๊ฐ’์€ ํ•˜๋‚˜๋กœ ํ•ฉ์ณ์ง„๋‹ค.) ex)SELECT 'hello'UNIONSELECT 'hi'UNIONSELECT 'hello'; UNION ALLํ•˜์ง€๋งŒ UNION์ด ์•„๋‹Œ UNION ALL์„ ์‚ฌ์šฉํ•˜๋ฉด ์ค‘๋ณต์ด ์‚ฌ๋ผ์ง€์ง€ ์•Š๋Š”๋‹ค.๊ทธ๋ฆฌ๊ณ  UNION ALL์€ ์ค‘๋ณต ์ฒดํฌ๋ฅผ ํ•˜์ง€ ์•Š์•„๋„ ๋˜๊ธฐ ๋•Œ๋ฌธ์— UNION๋ณด๋‹ค ์„ฑ๋Šฅ์ด ์ข‹๋‹ค.SELECT 'hello'UNION ALLSELECT 'hi'UNION ALLSELECT 'hello';..