DML(Data Mantipulation Language)

<aside> ๐Ÿ“Œ DML(DATA MANTIPULATION LANGUAGE)

๋ฐ์ดํ„ฐ ์กฐ์ž‘ ์–ธ์–ด

ํ…Œ์ด๋ธ”์— ์ƒˆ๋กœ์šด ๋ฐ์ดํ„ฐ๋ฅผ ์‚ฝ์ž…(INSERT)ํ•˜๊ฑฐ๋‚˜ ๊ธฐ์กด์˜ ๋ฐ์ดํ„ฐ๋ฅผ ์ˆ˜์ •(UPDATE)ํ•˜๊ฑฐ๋‚˜ ์‚ญ์ œ(DELETE)ํ•˜๋Š” ๊ตฌ๋ฌธ

</aside>

INSERT ๊ตฌ๋ฌธ

INSERT ALL ๊ตฌ๋ฌธ

UPDATE ๊ตฌ๋ฌธ

DELETE ๊ตฌ๋ฌธ

TRUNCATE ๊ตฌ๋ฌธ

DDL(Data Definition Language)

<aside> ๐Ÿ“Œ DDL : ๋ฐ์ดํ„ฐ ์ •์˜ ์–ธ์–ด

โ†’๊ฐ์ฒด๋“ค์„ ์ƒˆ๋กญ๊ฒŒ ์ƒ์„ฑ(CREATE), ์ˆ˜์ •ํ•˜๊ณ , ์‚ญ์ œํ•˜๋Š” ๊ตฌ๋ฌธ

</aside>

ALTER ๊ตฌ๋ฌธ