DELETE ๋ฌธ 1
[SQL] DELETE ๋ฌธ

1. DELETE ๋ฌธ - ํ…Œ์ด๋ธ”์— ์žˆ๋Š” ๋ฐ์ดํ„ฐ๋ฅผ ์‚ญ์ œํ•  ๋•Œ ์‚ฌ์šฉ - WHERE ์ ˆ์„ ์ƒ๋žตํ•˜๋ฉด ํ…Œ์ด๋ธ”์˜ ๋ชจ๋“  ํ–‰์„ ์‚ญ์ œ DELETE [FROM] [ํ…Œ์ด๋ธ” ์ด๋ฆ„] [WHERE ์‚ญ์ œํ•  ๋Œ€์ƒ ํ–‰์„ ์„ ๋ณ„ํ•˜๊ธฐ ์œ„ํ•œ ์กฐ๊ฑด์‹]; -- 1. ๋ฐ์ดํ„ฐ ์ผ๋ถ€๋ถ„๋งŒ ์‚ญ์ œํ•˜๊ธฐ DELETE FROM EMP_TEMP WHERE JOB = 'MANAGER'; -- 2. ๋ฐ์ดํ„ฐ ์ „์ฒด ์‚ญ์ œํ•˜๊ธฐ DELETE FROM EMP_TEMP (1) EMP_TEMP ํ…Œ์ด๋ธ”์—์„œ JOB ์นผ๋Ÿผ์ด MANAGER์ธ ํ–‰๋งŒ ์‚ญ์ œ (2) EMP_TEMP ํ…Œ์ด๋ธ”์˜ ๋ชจ๋“  ํ–‰ ์‚ญ์ œ 2. ์„œ๋ธŒ์ฟผ๋ฆฌ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋ฐ์ดํ„ฐ ์‚ญ์ œํ•˜๊ธฐ - DELETE ๋ฌธ ์—ญ์‹œ WHERE ์ ˆ์— ์„œ๋ธŒ์ฟผ๋ฆฌ ์‚ฌ์šฉ์ด ๊ฐ€๋Šฅ -- 1. ์„œ๋ธŒ์ฟผ๋ฆฌ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋ฐ์ดํ„ฐ ์ผ๋ถ€๋งŒ ์‚ญ์ œํ•˜๊ธฐ DELETE FROM EMP_TEM..
ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์–ธ์–ด/DataBase 2021.03.11
1
๋”๋ณด๊ธฐ

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”